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

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

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