Count # Workdays b/t two dates?

[Guest]

I can easily do this with the "NETWORKDAYS" function in the analysis toolpak, however not everyone on my distribution has this add-in.

How can I count the number of workdays (m-f) between to dates with a formula/function?

 

[Jason Morin]

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(C1&":"&D1)),3)<5))

where C1 holds start date and D1 holds end date.

HTH
Jason
Atlanta, GA

-----Original Message-----
I can easily do this with the "NETWORKDAYS" function in

the analysis toolpak, however not everyone on my
distribution has this add-in.

 

[Peo Sjoblom]

One possible way

=((A2-A1)+1)-((SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))={1,7})))+SUMP
RODUCT(--(Holidays>=A1),--(Holidays<=A2)))

where A1 holds the start date and A2 holds the end date and Holidays is a
range that includes the public holidays

--

Regards,

Peo Sjoblom

I can easily do this with the "NETWORKDAYS" function in the analysis

toolpak, however not everyone on my distribution has this add-in.

How can I count the number of workdays (m-f) between to dates with a

formula/function?

 

[Jason Morin]

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)),3)<5))

HTH
Jason
Atlanta, GA

-----Original Message-----
I can easily do this with the "NETWORKDAYS" function in

the analysis toolpak, however not everyone on my
distribution has this add-in.