| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Function
It didn't look as though the OP wanted to skip weekend dates, but we shall
await a response. -- David Biddulph "Mike H" wrote in message ... try this, Add 3 working days to a1. Holidays is a named range that contains any national holidays =WORKDAY(A1,3,Holidays) Mike "HARSHAWARDHAN. S .SHASTRI" wrote: 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 | |||
![David Biddulph[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
