how do i force an value to "jump over weekends"

[des-sa]

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

 

[Mike H]

Try

=WORKDAY(TODAY(),4)

Mike

 

[des-sa]

Mike,
Returns #NAME

Try

=WORKDAY(TODAY(),4)

Mike

 

[Mike H]

Sorry I should have mentioned

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

Tools|Addins| check analysis toolpak

Mike

 

[muddan madhu]

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,A1+4))

 

[Sandy Mann]

Slightly shorter:

=A1+4+((3-(WEEKDAY(A1+4,2)-5))*(WEEKDAY(A1+4,2)>5))

But it will not take holidays into account like WORKDAY() does.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk


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,A1+4))