Count # Workdays b/t two dates?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
=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
Click to expand...
the analysis toolpak, however not everyone on my
distribution has this add-in.
 
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


[email protected] said:
I can easily do this with the "NETWORKDAYS" function in the analysis
Click to expand...
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
Click to expand...
formula/function?
 
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)),3)<5))

HTH
Jason
Atlanta, GA
-----Original Message-----
I can easily do this with the "NETWORKDAYS" function in
Click to expand...
the analysis toolpak, however not everyone on my
distribution has this add-in.
 
Back
Top