# Display dates between a beginning date and an ending date

1. ## 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.

2. ## 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

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. ## 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. ## Re: Display dates between a beginning date and an ending date

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

6. ## Re: Display dates between a beginning date and an ending date

You're welcome.

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

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

#### 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