G
Guest
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
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