Timesheet Date Calculation
 

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)


"HRMSN" wrote in message
...
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.