Missing formulae

[bpeirson]

I am using Microsoft Excel 2002 at work as are all the other folks here.

I recently transfered a template to the other computers in the office and discovered that I have the built in function/formula "WORKDAY". This formula will return the specific date which is a certain number of workdays away from "TODAY()".

The other computers in the office don't have this function and I don't know/remember where I got this formula from.

If anyone can shed some light on the location of this formula either on the internet for download or even on my harddrive so I can copy it I would very much appreciate the help.

 

[analogkid2digitalman]

Could it be a function from an Add-In that is not applied in other machines? Check Tools/Add-Ins on your machine to see if any are checked. Then check on another machine where it is not working. I am not certain, but a similar situation arose with me a while back.


Wheels within wheels / In a spiral array
A pattern so grand / And complex
Time after time / We lose sight of the way
Our causes can't see / Their effects.

 

[bltseattle]

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

Load add-ins from the "TOOLS>ADD-INS" menu. Analysis ToolPak is included with Excel as far as I can tell.

 

[MortenA]

Could is be in a module atteched to your "personal" sheet (that autoload hidden)? I have some macro that i developed myself. I have copy them to a sheet before giving them away to other people.

Best regards

Morten

 

[Cockroach]

I got around it by using NOW() and formating the cell to DD-MMM-YY. The typical Excel spreadsheet uses TODAY() which was not recognized on my Pocket PC, HP iPAC mobile device.

I guess where there is will, there is a way!

Kenneth J Hueston, PEng
Principal
Sturni-Hueston Engineering Inc
Edmonton, Alberta Canada

 

[bpeirson]

"ADD-INS" was where the formula was located.

It's good to have a forewarning about the NOW()-TODAY() function as I use TODAY() exclusively in my worksheets.

Thanks to all.