Thread: WORKDAY Help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default WORKDAY Help

Hi,

They're part of the ATP so
Tools|Addins and load the analysis toolpak.

Mike

"S Boak" wrote:

Hi Folks:

Thought this would be simple . . . .
Trying to get the number of work days in C1 from dates in A1 and B1

A1: First Day of month
B1: Last Day of month
C1:

=WORKDAY(A1,B1)
or
=NETWORKDAYS(A1,B1) both return #NAME?

Any help appreciated - Thanks
Steve