count weekdays only

[rp]

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

 

[Govind]

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]

=(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