Excluding holidays when counting period

[stepan1987]

Guys,
I need to make a big number of calculations using for different periods..
Is there a way to exclude weekends and a list of specific days which where holidays and are not applicable everytime I use period calculations in a formula?
Excluding them manually is not applicable as the number of required calculations is huge..

Thanks!

 

[number kruncher]

You should use NETWORKDAYS, eg.

=NETWORKDAYS(C1,C2,A1:A2)

C1 = Date to start from
C2 = Date to end on

A1:A2 range of excluded dates, (make bigger to suit)

This automatically excludes weekends.

 

[stepan1987]

Cool, thanks, think that'll work!