Is there a difference in formula between.........

[aarat260980]

Hello There
I was jst wondering whether there is any difference in formula for MS Excel 97 and Excel 2000.

What i am trying to do is calculate 20 days from start of application and am using formula as this.:
=WORKDAY(B8,20,{"02/05/2005"}
so if the start date is 06/04/05 the end date should be 05/05/05. remember its 20 working days minus a bank holiday.
This formula works perfectly on Excel 2000 but when my colleague tries to access it on Excel 97 this error pops up - #NAME?
Please help me

Thanks

Aarat

Aarat H Patel

 

[Shippwreck]

Hi,

Is Workday a user defined function, if it is then it wont work on a different machine unless they also have the same user defined function?

Shippwreck

http://www.orlandoluxuryvilla-pool.com

 

[SkipVought]

Hi,

WORKDAY function is a Analysis ToolPak Add-in for Excel.

Skip,
[sub]
[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart! [/sub]

 

[Shippwreck]

So then that would say to me that the Analysis ToolPak is either not installed on that machine, or cannot be used with '97

I don't know any specifics about that ToolPak but after typing it into Google it appears that it is compatible with '97 so that would lead me to believe that it is not installed.

Also as it is an add-in and not a built in feature then surely the format that you enter the function should be the same no matter what version you are using which leads back to it not being installed.

Shuppwreck

http://www.orlandoluxuryvilla-pool.com

 

[aarat260980]

hello all
thanks for responses but it does not actually help me. i found out its an analysis tool pack but still am stuck

Appreciate your help

Thanks
Aarat

Aarat H Patel

 

[xlbo]

You need to install the analysis toolpak add-in then don't you.......that's the only way they'll be able to use the WORKDAY function

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question

 

[aarat260980]

is there any place i can download it from?

Thanks

Aarat H Patel

 

[aarat260980]

dont worry guys now i have done it
thanks for your help

Aarat H Patel