A question about Excel dates?

[sooze29]

I have been asked if Excel is able to work out future dates. For example by putting in the date of an AGM as 5 February, it can calculate the date of 10 business days later (which would be 19 Feb).

They also asked if it would also know if there were bank holidays in that date range.

I don't know it is 'clever' enough but have been asked to put it to a forum.

Many thanks

 

[SkipVought]

Hi,

Check out the WORKDAY function.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[sooze29]

Many thanks, we don't have that add in though, but maybe with a later version.

 

[mintjulep]

The analysis tool pack is part of the standard Excel package, you just need to go to Tools | Add Ins... and check it.

 

[SkipVought]

It's the Analysis ToolPak add-in.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[AnotherHiggins]

What version of excel are you running??

WORKDAY is in the Analysis Toolpak. Go to Tools > Add-Ins and check the box beside Analysis Toolpak.

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.