| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Function
I have a work sheet in which column A is having "Recd On" (Date). column B is having "Dispatch On" (Date). If there is no holiday Dispatch On date = Recd On Date +3 . Column H is having list of dates on which there is holiday. What i want is a formula which will give me Dispatch Date which is not a holiday. For example if recd date is 24/09/2008 and there is holiday on 27/9/08,28/9/08,30/9/08 then Dispatch Date should be 01/10/08. Harshawardhan.Shastri India |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date function in ACCRINTM requires date format not available | Excel Worksheet Functions | |||
| MAX figure within a date range as a function of today()'s date | Excel Worksheet Functions | |||
| SUMIF within date range as a function of today()'s date | Excel Worksheet Functions | |||
| Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
![HARSHAWARDHAN. S .SHASTRI[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
