+ Reply to Thread
Results 1 to 7 of 7

List All Dates Between Two Dates In Excel

  1. #1
    Registered User
    Join Date
    09-21-2019
    Location
    US
    MS-Off Ver
    Office 365
    Posts
    4

    Question List All Dates Between Two Dates In Excel

    I am trying to get a column of dates between two dates. Every date outside of the date range, I do not want to be shown in the column.

    Start Date (E4) 9/1/19
    End Date (H4) 9/15/19

    My column/cells for the dates (A8) - (A24)

    I want (A8) to show the date 9/1/19, (A9) 9/2/19, (A10) 9/3/19 etc. to (A21) 9/15/19.

    Then (A23-A24) to be blank because they are outside of the End Date in (H4).

    With the formula I am using, it does not stop showing dates outside of the end date.

    So this is the formula I am using:
    Please Login or Register  to view this content.
    This is working on adding the dates. The problem I am having is that Cell (A23) & (A24) is showing the dates outside of the end date. So after 9/15/19 the other cells (A23) & (A24) should remain blank.

    I am not sure why it is adding the other dates when I say
    Please Login or Register  to view this content.
    Can someone please help. Thanks

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    29,538

    Re: List All Dates Between Two Dates In Excel

    A9:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    copied down.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    09-21-2019
    Location
    US
    MS-Off Ver
    Office 365
    Posts
    4

    Re: List All Dates Between Two Dates In Excel

    That does work with the date of 9/1/19 - 9/15/19. However when I change the date to 9/16/19 - 9/30/19. Then I get the same problem to where it shows 10/1/19 & 10/2/19. Which I do not want it to show as it is outside of the end date.

    These dates will change depending on different factors. As an example:

    Start -- End
    1/1/19 -- 1/15/19
    1/16/19 -- 1/31/19
    2/1/19 -- 2/15/19
    2/16/19 -- 2/28/19
    3/1/19 -- 3/15/19
    3/16/19 -- 3/31/19
    etc
    etc

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    29,538

    Re: List All Dates Between Two Dates In Excel

    Set A8 as
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    and it should be OK

  5. #5
    Registered User
    Join Date
    09-21-2019
    Location
    US
    MS-Off Ver
    Office 365
    Posts
    4

    Re: List All Dates Between Two Dates In Excel

    Sadly that did not do the trick.

  6. #6
    Registered User
    Join Date
    09-21-2019
    Location
    US
    MS-Off Ver
    Office 365
    Posts
    4

    Re: List All Dates Between Two Dates In Excel

    I found the problem. That did work. I just had mistyped the end date.

    Thanks for your help and time. God Bless you.

  7. #7
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    29,538

    Re: List All Dates Between Two Dates In Excel

    I just had mistyped the end date.
    I was never going to find that

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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