Workday function

[JohnV]

The WORKDAY function is not listed in the list for Date & Time functions in the selection window for functionsin my version of EXCEL 97-2000, but in the Excel Help Index listing, it is. Is the WORKDAY function not included in some versions of EXCEL. In what version is WORKDAY available or how can I add it to the Date & Time functions list?

 

[Mark W.]

On 2002-10-10 12:37, JohnV wrote:
The WORKDAY function is not listed in the list for Date & Time functions in the selection window for functionsin my version of EXCEL 97-2000, but in the Excel Help Index listing, it is. Is the WORKDAY function not included in some versions of EXCEL. In what version is WORKDAY available or how can I add it to the Date & Time functions list?

The WORKDAY function is supplied by the Analysis ToolPak. See the Excel Help topic for "WORKDAY".

 

[IML]

from the help file
WORKDAY
See Also

Returns a number that represents a date that is the indicated number of working days before or after a date (the starting date). Working days exclude weekends and any dates identified as holidays. Use WORKDAY to exclude weekends or holidays when you calculate invoice due dates, expected delivery times, or the number of days of work performed.

If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in.

good luck