Display dates between a beginning date and an ending date

**krwi** · 02-15-2012, 04:59 PM

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.

**TMS** · 02-15-2012, 05:41 PM

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

**krwi** · 02-15-2012, 06:24 PM

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

**TMS** · 02-15-2012, 06:42 PM

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

**krwi** · 02-15-2012, 06:51 PM

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

**TMS** · 02-15-2012, 06:54 PM

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