Thanks! I'll try that.
--
JoAnn


"JE McGimpsey" wrote:

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