Lotus Formula for Excel?

[staffie007]

Hey Guys,

I have a problem that I wonder if anyone can help me with...

The Lotus formuala @workday(@now,14) is able to calculate 14 working days from now and I need something like that for Excel.

Not number of working days between two dates.

The major problem for me is the fact that it has to be a formula and not VBA.

Can anyone help?

 

[Aladin Akyurek]

Probably...

=WORKDAY(TODAY(),14)

 

[staffie007]

Nope... That doenst work... Atleast not in Excel 2003

 

[Aladin Akyurek]

Nope... That doenst work... Atleast not in Excel 2003

You need to activate the Analysis Toolpak add-in (see Tools|Add-Ins).

 

[staffie007]

Thanks... It works!

Sorry, I never realised I needed to add in that!

Will that work in Excel 2000?

 

[Aladin Akyurek]

Thanks... It works!

Sorry, I never realised I needed to add in that!

Will that work in Excel 2000?

Yes.

 

[staffie007]

Thanks so much