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

  • Thread starter Thread starter des-sa
  • Start date Start date
D

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
 
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
 
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))
 
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))
 
Back
Top