networkdays

[BrutalLogiC]

hello i have a problem with counting the number of working days (mon-fri) between two dates and don't know what I'm doing wrong. I'm using excel 2003.

G22 is 25/03/2011
G23 is 31/07/2011
G24 is =NETWORKDAYS(G22,G23)

 

[Andrew Poulsom]

For me your formula returns 91. In what way isn't it working for you? To use the NETWORKDAYS function the Analysis ToolPak Add-In must be installed.

 

[VoG]

That returns 91 for me.

Make sure that the Analysis Toolpak is installed in Tools > Add-Ins.

 

[BrutalLogiC]

thanks guys, that was the problem