| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for finding Date difference between 2 dates
Hi,
Please help me to find a formula for calculating the number of days between 2 dates excluding the dates given in a range. Networkdays function doesnt work as it excludes Saturday & sundays. Example: Cell A1 = 3-Mar-2009 Cell A2 = 15 March 2009 My Holiday list contains in Column Range E1:E5 E1 = 6-Mar-2009 E2 = 7-Mar-2009 E3 = 13-Mar-2009 E4 = 20-Mar-2009 E5 = 27-Mar-2009 Answer should be 15 - 3 - (3 Holidaysfalls between the Dates )) = 9 days. Can Anuone help me please . I am desperately looking for an answer... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| finding if a date falls between two dates | Excel Discussion (Misc queries) | |||
| finding if a date falls between two dates | Excel Discussion (Misc queries) | |||
| What is a formula for finding the largest date in a list of dates? | Excel Discussion (Misc queries) | |||
| finding date difference | Excel Discussion (Misc queries) | |||
| Finding dates within a date range | Excel Worksheet Functions | |||
Threaded Mode
