Yearplanner

[Andre]

Hello everybody,

I'm making a yearplanner, but i want to cut out de weekend days and the hollidays. So i'll only have the working daysin my planner. Besides that i don't want fill the range by hand each year.I want to do this with a formula. Is there somebody that can help me?

 

[Aladin Akyurek]

On 2002-09-08 01:07, Andre wrote:
Hello everybody,

I'm making a yearplanner, but i want to cut out de weekend days and the hollidays. So i'll only have the working daysin my planner. Besides that i don't want fill the range by hand each year.I want to do this with a formula. Is there somebody that can help me?

Have a look at the WORKDAY function (from the Analysis Toolpak add-in).

 

[Andre]

Thanks Aladin.

I've tried that earlier. A collegue offert me the same sugestion. But in the version of Excel i'am working with (excel 2000 pro) there is no such function.

I've allready defined the hollidays and the days of the week in numbers. But i can't complete the formule i need

(Example)
=Werkdag(C2;1;Blad2!$A$18:$A$55)

The above formule is the one i got from my collegue, but it doesn't work

 

[Aladin Akyurek]

On 2002-09-08 01:37, Andre wrote:
Thanks Aladin.

I've tried that earlier. A collegue offert me the same sugestion. But in the version of Excel i'am working with (excel 2000 pro) there is no such function.

I've allready defined the hollidays and the days of the week in numbers. But i can't complete the formule i need

(Example)
=Werkdag(C2;1;Blad2!$A$18:$A$55)

The above formule is the one i got from my collegue, but it doesn't work

You need to activate the Analysis Toolpak add-in via Tools|Add-Ins (Tools is an option on the Menu bar -- the one after "Opmaak" in the Dutch version).