Thread: Total Leave
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tia[_3_] Tia[_3_] is offline
external usenet poster
 
Posts: 79
Default Total Leave

Dear Sir,

I am working on annual leave and i want to have total days for 7 days
not networkdays excluding the weekend
i want the total number of days excluding the holidays

B18= Start Date
C18= End Date
Holidays ='Main'!B73:B100

What is the formula that i should use to count the total of days
execpt the holidays

Thank you in advance