Missing formulae
Missing formulae
(OP)
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.
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.





RE: Missing formulae
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.
RE: Missing formulae
Load add-ins from the "TOOLS>ADD-INS" menu. Analysis ToolPak is included with Excel as far as I can tell.
RE: Missing formulae
Best regards
Morten
RE: Missing formulae
I guess where there is will, there is a way! :)
Kenneth J Hueston, PEng
Principal
Sturni-Hueston Engineering Inc
Edmonton, Alberta Canada
RE: Missing formulae
It's good to have a forewarning about the NOW()-TODAY() function as I use TODAY() exclusively in my worksheets.
Thanks to all.