Date Range for my time sheet

[PamelaT]

my payperiods run from the1st to the 15th and 16th to end of the month. i
currently have a time sheet displaying a start date:
L4
and then each consecutive day as:
$L$4+1
$L$4+2 and so on up to $L$4+15 (to cover all
months)
but in feb for example the dates populate into the next pay period.
is there a better way to auto populate just the fields in the current pay
period or to HIDE the rows that are outside the pay period?

Thanks from the newbie!!

 

[daddylonglegs]

Where do you have =$L$4+1? If it's in L5 try this formula instead

=IF(L4="","",IF(DAY(L4+1)>DAY(L4),L4+1,""))

format as date and copy down column

 

[PamelaT]

Thankyou daddylonglegs! that worked beaautifully!!