Networkdays

Omar Ahmad · Feb 27, 2004

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 · Feb 27, 2004

Perhaps:

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

Omar Ahmad · Mar 1, 2004

Vasant Nanavati,

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

Ombaf

Vasant Nanavati · Mar 1, 2004

You're very welcome! Thanks for the feedback.

Omar Ahmad said:
Vasant Nanavati,

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

Ombaf