| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| One should be able to "jump" over undo command in Excel | Excel Discussion (Misc queries) | |||
| Creating a search and "jump to" function | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Make typing "jump" to matching item(s) in drop-down list? | Excel Discussion (Misc queries) | |||
![des-sa[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
