Date Range for my time sheet
 

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

Date Range for my time sheet
 

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=516697

Date Range for my time sheet
 

Thankyou daddylonglegs! that worked beaautifully!!

"daddylonglegs" wrote:


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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=516697