| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to exlude holidays from a range of dates
Dear Excel Expert User,
I have in sheet 1 a list of holidays : 01/01/2007 in A1, 25/12/2007 in A2 etc... In Sheet 2, I have in A1 a start date and time and in B1 an end date and time. I would like to calculate the lead time between B1 and A1, excluding the holidays dates in sheet 1. Thanks a lot, Excel Dubai |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting and error while calculate business hours between 2 dates with holidays. | Excel Worksheet Functions | |||
| Take an average of a range of cells but exlude blanks from that av | Excel Discussion (Misc queries) | |||
| Dates with Holidays question | Excel Discussion (Misc queries) | |||
| fill a series of dates excluding holidays | Excel Worksheet Functions | |||
| Skip holidays falling between two dates | Excel Worksheet Functions | |||
![Excel Dubai[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
