Date calculation question
If you include the time in the submission date, one way:
A1: 27 February 2008 3:30 pm
B1: =WORKDAY(A1,3+(MOD(A1,1)15/24), holidays)
assuming no holidays, this will return 4 March 2008
another, simpler, way:
B1: =WORKDAY(A1+8.99999/24,3)
In article ,
JoAnn wrote:
I have a submission date (reg date field) & an expected due date (using
Workday to calculate 3 workdays from submission date, minus holidays). I
would like to change the due date so if the document is submitted after
3:00pm, an extra day is added.
How would I do this?
Thanks,
JoAnn
|