Ask Your Question

Automatic series for weekdays [closed]

asked 2018-01-14 16:14:36 +0100

TomTomTom gravatar image

Hi, I'm searching for a way to automatically generate a series of calendar dates for specific weekdays, for example every Tuesday and Thursday of each week. This doesn't work with the usual select short series & extend feature that will for example automatically create a series of all the consecutive calendar dates.

Can you help me?

Cheers, Tom

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by TomTomTom
close date 2018-01-14 21:11:53.613396

1 Answer

Sort by » oldest newest most voted

answered 2018-01-14 17:04:18 +0100

updated 2018-01-14 17:07:55 +0100

Well: if I have a short series like this: 2018-01-14 (in A1); 2018-01-21 (in A2); then I can select these two, and extend down, and it works for me (giving Jan 28th, Feb 4th, Feb 11th, etc).

Further: if I put 2018-01-14 into A1, and =A1+7 into A2, then I can simply copy the A2 and paste into all the cells I need below.

You could extend the formula sample, like putting first weekday (for Tuesday) into A1, second (Thursday) into A2, and put =A1+7 into A3, then copy the A3 down.

edit flag offensive delete link more


Thanks, Mike!

This had been bugging me for a long time. I'm glad that there is such a straightforward and simple solution. Made my day!

All the best, Tom

TomTomTom gravatar imageTomTomTom ( 2018-01-14 21:11:17 +0100 )edit

If the answer solves your question please tick the ✔.

m.a.riosv gravatar imagem.a.riosv ( 2018-01-14 23:18:27 +0100 )edit

Question Tools

1 follower


Asked: 2018-01-14 16:14:36 +0100

Seen: 64 times

Last updated: Jan 14 '18