Networkdays

[Omar Ahmad]

Hi all,

I need to calculate the number of working days for a 7 day work-week,
excluding holidays which I have listed.
Can anyone help, please

Ombaf

 

[Vasant Nanavati]

Perhaps:

=EndDate-StartDate+1-SUMPRODUCT((Holidays>=StartDate)*(Holidays<=EndDate))

 

[Omar Ahmad]

Vasant Nanavati,

Thank you so very much. You saved me a lot of worry and sweat. Many thanks
once again.

Ombaf

 

[Vasant Nanavati]

You're very welcome! Thanks for the feedback.

Vasant Nanavati,

Thank you so very much. You saved me a lot of worry and sweat. Many thanks
once again.

Ombaf