Timesheet Date Calculation

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

Guest

In designing a time sheet, I need help with a function that will calculate
two weeks worth of dates after the person puts the first date of that pay
period into the timesheet. The catch is, I need the function to no put
nothing in each spot if that first date is not entered. Can anyone help? I
believe it will be an IF function but as of yet I have been unable to make it
work.
 
=IF($A$1="","",A1+1)

in B1.

If you need to ignore weekends, use

=IF($A$1="","",A1+1+(WEEKDAY(A1)=6)*2)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Back
Top