×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Missing formulae

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.

RE: Missing formulae

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.

RE: Missing formulae

"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.

RE: Missing formulae

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

RE: Missing formulae

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

RE: Missing formulae

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login



News


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close