TRY this !!!!

suppose u have in A1 u have expected delivery date

A1 has todays date as 30/05/2008 + 4days

B1 put this formula
=IF(WEEKDAY(A1+4)=1,A1+5,IF(WEEKDAY(A1+4)=7,A1+6,A 1+4))




On May 30, 3:59*pm, des-sa wrote:
Mike,
Returns #NAME



"Mike H" wrote:
Try

=WORKDAY(TODAY(),4)

Mike

"des-sa" wrote:

please help,
suppose i want to indicate to a client that his expected delivery date is
today + 4 days, but if that date falls on a saturday or sunday, it should
return the first workday thereafter. *is is possible, how?
thanks- Hide quoted text -

- Show quoted text -