Hoping someone can help with this Excel 2007 vs. earlier versions

[KillyKillall]

Hello all,

I'm hoping someone can help provide some insight into this issue I'm experiencing in Excel.

I have created a spreadsheet in Excel 2007 and within it contains the following need:

Essentially, I'm trying to scope a date for a work complete date. I'm doing this by having a cell in which the user inputs a date, a new cell then looks at the appropriate amount of weeks needed to do the work above and then reports out an estimated work complete date.

Example:

Cell K24 = Contains a number representing weeks scoped for work
Cell K27 = User enters begin work date

Cell K30 performs the following calculation: =WORKDAY(K27,K24*5)

This formula works in Excel 2007, but in previous versions it just shows #NAME?. Does this mean the formula is not compatible with an earlier version or am I doing this wrong?

Thank you in advance for any insight.

 

[mayest]

You need to enable the Analysis ToolPak in prior versions of Excel. Go to Tools --> Add-ins and make sure that there is a check mark next to that add-in (you don't need the VBA version of it). That will also make a whole bunch of other additional functions become available. In Excel 2007 all of those functions were moved out of the add-in (which still has other good stuff, so it is worth enabling) and into Excel itself.

If Analysis ToolPak isn't in the list of available add-ins, then you will need the installation CD and do a custom install. That will allow you to add any missing features.

 

[WildHorse]

As you know, there's project management software designed expressly for the type of task you describe.

One is the expensive MS Project.

Another is the free, open source alternative to MS Project, which works great - I've been using it for a few years to help me manage complicated, profitable real-world projects. Maybe this type of application would be better suited than Excel for what you're doing?

Have a look:

Open Workbench