Date Range for my time sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Start Day of Bi-Monthly Pay Period 9
How do I use the IF function with info that contains a date? 1
Divide month into two payroll periods 5
dates from a data validation 3
Help needed with a formula for dates in excel 2007 2
How do I create a total sheet 2
Excel Help with dates 2
Using Vlookup with multiple sheet 3

Back
Top