WORKDAY not working for Aug. 15th?

[cicconmr]

Is any one else having this problem...

I've tried several ways (never had a problem before) here is what I get:

1) WORKDAY(day(15),-1,holidays) Reutrning: 13
2) WORKDAY(DATE(2011,8,15),-1,holidays) Returning: 4/17/2101

Is any one having errors today? I have to use -2 in example 1 to get 12, the second one should work and it doesnt at all....?

Matt

 

[RoryA]

The first one returns the work day before the 15th Jan 1900.
The second works fine for me - which version of Excel are you using?

 

[cicconmr]

2007, if analysis tool pack wasn't working wouldn't it not be out putting anything?

This is baffling me.

 

[cicconmr]

Here was the problem.

The cell with WorkDay in it was not formatted as a date, therefor it was given off what I'm assuming was the date code?

And that would appear to be the issue, now everything seems to be working....I apologize for this. Hopefully someone will find this thread useful in the future

 

[RoryA]

In 2007, the functions are built-in rather than being part of the ATP.
I was testing in 2010, have just tested in 2007 and it works fine there too.