+ Reply to Thread
Results 1 to 6 of 6

Display dates between a beginning date and an ending date

  1. #1
    Registered User
    Join Date
    02-15-2012
    Location
    Cheney WA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Display dates between a beginning date and an ending date

    Our payroll cycles are semi monthly and start on the 3rd and the 18th of every month. I would like to be able to enter the pay period start date and the pay period end date and have it automatically fill in the dates on the side no matter how many days are in that pay period. It seems to be determined by the number of lines I pick. For instance some are 15 days and some are 14 days and I only want it to list the days within that period. Thoughts?

    I have attached what I have and have manually entered what I need.
    Attached Files Attached Files

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

    Re: Display dates between a beginning date and an ending date

    G26: =K23 as now (start date)
    G27: =IF(G26+1>$K$25,"",G26+1) and copy down

    However, if you display the 2nd, you are actually displaying 16 dates, not 15


    Regards, TMS
    Last edited by TMS; 02-15-2012 at 05:43 PM.
    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
    02-15-2012
    Location
    Cheney WA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Display dates between a beginning date and an ending date

    So how far down do I drag because when I drag to far I get #value

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

    Re: Display dates between a beginning date and an ending date

    A27: =IFERROR(IF(A26+1>$E$25,"",A26+1),"")
    G27: =IFERROR(IF(G26+1>$K$25,"",G26+1),"")
    M27: =IFERROR(IF(M26+1>$Q$25,"",M26+1),"")

    drag down as far as you want but I'm not sure why you want to; you were only "missing" one date and I'm not even sure you need that:

    For instance some are 15 days and some are 14 days and I only want it to list the days within that period

    Regards, TMS

  5. #5
    Registered User
    Join Date
    02-15-2012
    Location
    Cheney WA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Display dates between a beginning date and an ending date

    You are the best - thank you so much for your help!

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    38,939

    Re: Display dates between a beginning date and an ending date

    You're welcome.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save

+ 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