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