View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Myrna Larson Myrna Larson is offline
external usenet poster
 
Posts: 863
Default 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