# How to count dates in the format Monday, Jan 1, 2020

1. ## How to count dates in the format Monday, Jan 1, 2020

Hi,

Does anyone know the formula for counting consecutive dates in the following format for a couple of years? Each date (Monday, Mar 16, 2020) is in one cell and so on for 2 weeks horizontally and then the next row begins the next Monday. For example, A1 - A14 is Monday through Sunday for 2 weeks then B1 - B14 is Monday through Sunday for the next 2 weeks, etc., etc.

Monday, Mar 16, 2020 Tuesday, Mar 17, 2020 Wednesday, Mar 18, 2020 Thursday, Mar 19, 2020 Friday, Mar 20, 2020 Saturday, Mar 21, 2020 Sunday, Mar 22, 2020 Monday, Mar 23, 2020 Tuesday, Mar 24, 2020 Wednesday, Mar 25, 2020 Thursday, Mar 26, 2020 Friday, Mar 27, 2020 Saturday, Mar 28, 2020 Sunday, Mar 30, 2020
Monday, Mar 30, 2020 Tuesday, Mar 31, 2020 Wednesday, Apr 1, 2020 Thursday, Apr 2, 2020 Friday, Apr 3, 2020 Saturday, Apr 4, 2020 Sunday, Apr 5, 2020 Monday, Apr 6, 2020 Tuesday, Apr 7, 2020 Wednesday, Apr 8, 2020 Thursday, Apr 9, 2020 Friday, Apr 10, 2020 Saturday, Apr 11, 2020 Sunday, Apr 12, 2020

2. ## Re: How to count dates in the format Monday, Jan 1, 2020

Try this

In Cell A1 put "Monday, March 16, 2020" drag that down till weeks so till A14 then in B1 put =A1+14 then drag that down to B14 then with B1 thru B14 selected just drag that to the right until you have 2 years worth of data

3. ## Re: How to count dates in the format Monday, Jan 1, 2020

korekurd - That doesn't work... and I get #VALUE! errors. Also, did you notice it's

A1 = Monday, Mar 16, 2020
A2 = Tuesday, Mar 17, 2020
A3 = Wednesday, Mar 18, 2020
A4 = Thursday, Mar 19, 2020 and so on, then it's B1 14 days after A1 with NOT only a different number but a different month as well in B3...
...
B1 = Monday, Mar 30, 2020
B2 = Tuesday, Mar 31, 2020
B3 = Wednesday, Apr 1, 2020
B4 = Thursday, Apr 2, 2020
...
and after 12 months worth, the year has to change as well.

4. ## Re: How to count dates in the format Monday, Jan 1, 2020

See image below is this what you need done?

Capture.PNG

5. ## Re: How to count dates in the format Monday, Jan 1, 2020

No, I messed up in the previous post... the image should be all Mondays in column A, all Tuesdays is Column B, all Wednesdays in column C and so on. Like this:

A1 = Monday, Mar 16, 2020 B1 = Tuesday, Mar 17, 2020 C1 = Wednesday, Mar 18, 2020... N1 = Sunday, Mar 29, 2020
A2 = Monday, Mar 30, 2020 B2 = Tuesday, Mar 31, 2020 C2 = Wednesday Apr 1, 2020 ...
A3 = Monday, Apr 13, 2020 B3 = Tuesday, Apr 14, 2020 C3 = Wednesday Apr 15, 2020...

6. ## Re: How to count dates in the format Monday, Jan 1, 2020

ok. Similar process just little different
Make sure you have the cells as date format

Then in Cell A1 put Monday, March 16, 2020 Drag that across to N1 you should have 2 weeks of dates
Then in Cell A2 put =A1+14 drag that across to N2 with A1 thru N2 Selected just drag that down until desired year.

See if you can open this excel

There are currently 1 users browsing this thread. (0 members and 1 guests)