count weekdays only

rp · Sep 27, 2004

how do i count weekdays only?
a1=01/01/04
a2=05/02/04
a3=no of weekdays

Govind · Sep 27, 2004

Hi rp,

User

=Networkdays(A1,A2)

However for this function to work you should have the Analysis Toolpak
add-in installed.To install the same, go to Tools->Add-In and check the
Analysis Toolpak add-in.

Regards

Govind.

sulprobil · Sep 27, 2004

=(A2-WEEKDAY(A2,2)+WEEKDAY(A1,2)-A1)/7*5-MIN(5,WEEKDAY
(A1,2))+MIN(5,WEEKDAY(A2,2))

I do not like big add-ins for small solutions

Regards,
sulprobil