+ Reply to Thread
Results 1 to 6 of 6

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

  1. #1
    Registered User
    Join Date
    03-12-2020
    Location
    Texas
    MS-Off Ver
    2013
    Posts
    6

    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. #2
    Registered User
    Join Date
    08-12-2020
    Location
    USA
    MS-Off Ver
    2016
    Posts
    18

    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. #3
    Registered User
    Join Date
    03-12-2020
    Location
    Texas
    MS-Off Ver
    2013
    Posts
    6

    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. #4
    Registered User
    Join Date
    08-12-2020
    Location
    USA
    MS-Off Ver
    2016
    Posts
    18

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

    See image below is this what you need done?

    Capture.PNG
    Last edited by korekurd; 09-21-2020 at 12:25 PM.

  5. #5
    Registered User
    Join Date
    03-12-2020
    Location
    Texas
    MS-Off Ver
    2013
    Posts
    6

    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. #6
    Registered User
    Join Date
    08-12-2020
    Location
    USA
    MS-Off Ver
    2016
    Posts
    18

    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
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Date Format 10.04.2020
    By ashishpatel34 in forum Excel General
    Replies: 9
    Last Post: 07-22-2020, 01:12 AM
  2. Replies: 4
    Last Post: 04-21-2020, 09:13 AM
  3. [SOLVED] Date Format : Thu, 2-Feb-2020
    By kayafueya in forum Excel General
    Replies: 2
    Last Post: 02-26-2020, 10:27 PM
  4. [SOLVED] Excel app won't accept 2020 dates on one tab, but will on other tabs
    By JimPT in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-12-2020, 01:16 PM
  5. Count if cell range dates are equal to monday
    By suban.p in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-13-2014, 10:12 AM
  6. [SOLVED] Count full weeks Monday thru Sunday between 2 dates
    By Tony Valko in forum Excel Formulas & Functions
    Replies: 32
    Last Post: 07-28-2014, 10:32 AM
  7. Replies: 12
    Last Post: 06-13-2014, 05:03 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1