Difference (weekdays) between two dates
 

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

Difference (weekdays) between two dates
 

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.

In article ,
ant1983 wrote:

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

Difference (weekdays) between two dates
 

From a post by Ron Coder

************************************
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


Replace @mailinator.com with @tiscali.co.uk


"ant1983" wrote in message
...
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

Difference (weekdays) between two dates
 

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?

"JE McGimpsey" wrote:

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.

In article ,
ant1983 wrote:

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

Difference (weekdays) between two dates
 

Have you installed the addin (ToolsAddins)?

--
HTH

Bob

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

"ant1983" wrote in message
...
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?

"JE McGimpsey" wrote:

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.

In article ,
ant1983 wrote:

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

Difference (weekdays) between two dates
 

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.


On Mon, 29 Oct 2007 05:41:00 -0700, ant1983
wrote:

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?

"JE McGimpsey" wrote:

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.

In article ,
ant1983 wrote:

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