Difference (weekdays) between two dates

[Guest]

Hi,

How do i calculate the difference between two dates? I only want to know
"work-days": Monday - Friday.

I know theres a calculation somewhere but cant find it....

Cheers,


Wayne

 

[JE McGimpsey]

Take a look at the entry for NETWORKDAYS() in XL Help. Note that it's an
Analysis Toolpak Add-in function for versions prior to XL07.

 

[Sandy Mann]

From a post by Ron Coderre:

************************************
With
A1: (startdate)
B1: (enddate)

If you have the Analysis ToolPak add-in installed
=NETWORKDAYS(A1,B1)

or...if you don't....
=SUM(INT((WEEKDAY(A1-{2,3,4,5,6})+B1-A1)/7))
***************************************

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Guest]

Thanks! Thats the one i was looking for though its giving me: #N/A.
(Nothing happens when i click on the Add-In... Am i not doing something?

 

[Bob Phillips]

Have you installed the addin (Tools>Addins)?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Myrna Larson]

If the ATP is not installed, the error is #NAME? not #N/A. Check Help for this
function to see what kinds of problems cause #N/A errors.