Workday Function in Excel 2007

J

Jeff

When I open up a spreadsheet that was created in 2003 inside of 2007 that has
the workday function in the sheet I get a #REF! error. The actual formula
changes to "=#REF!(Today(), -1, Holidays!A1:A5)". I also have made sure that
the Analysis ToolPak Add-In is installed. In fact, I uninstalled the add-in
and re-installed it to make sure that wasn't the issue. DOes anybody have an
explination for this behavior or is this a bug?

Thanks - Jeff
 
B

Biff

Don't know the reason but just some FYI info:

The Workday function is part of the ATP in Excel versions <=11. The ATP
functions have been "rolled into" the main application for Excel 2007, thus
not requiring an add-in. Maybe that has something to do with it but that is
such an obvious compatibility issue that surely MS would have dealt with it.

Biff
 
J

Jeff

I tried removing the Add-In to see if there was some compatability issue and
it seemed to make no difference.

Thanks for the response and the thought :)

- J
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Alternative to WORKDAY when Analysis ToolPak not loaded 9
WORKDAY Function 3
WORKDAY() Function Equivalent with SUMPRODUCT() 4
Workday function 0
Are PercentRank and Rankperc the same function? 1
I have a workaround 0
Problem with Analysis ToolPak Add-in 0
In WORKDAY function, how to exclude multiple/variable holiday rang 4

Top