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

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

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

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

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

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

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

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

"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

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

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 -

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

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


Replace @mailinator.com with @tiscali.co.uk


"muddan madhu" wrote in message
...
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 -