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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to exlude holidays from a range of dates
Go to Tools=Addins=Check "Analysis Toolpak" ATP)
Then look at NETWORKDAYS function (ATP required) This excludes weekends as well as holidays. HTH "Excel Dubai" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to exlude holidays from a range of dates
Dear Toppers,
The reason why netwook days will not work is because it takes into consideration the western week ends which are Starurday and Sunday. In middle east, the week ends are Friday and Saturday. Also, Network days takes into consideration full days whereas I want to calculate a leadtime in Days, Hours and Minutes. Thanks again Excel Dubai "Toppers" wrote: Go to Tools=Addins=Check "Analysis Toolpak" ATP) Then look at NETWORKDAYS function (ATP required) This excludes weekends as well as holidays. HTH "Excel Dubai" wrote: 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 |
Reply |
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 |