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
Bookmarks