A one page per view year planner

[Andrea L]

I would like a planner where I can list all employeees down the left hand
side, with all the dates of the year along the top, so that I can easily see
holidays booked for each person. A fomula on the right hand side to
claculate no. holidays booked ofr each person would be a bonus. Any chance
of that in time for 2006 or will I need to create my own?

Regards Andrea

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions

 

[Gary L Brown]

Any chance of that in time for 2006 or will I need to create my own?
Excel only has 256 columns so 356 columns or even 260 (52 x 5) is out of the
question UNTIL Excel 12 comes out next summer.

If you put employees at the top, however, and dates down the left hand side,
this can easily be done.

You could have codes such as 'H' for Holiday, 'V' for Vacation, 'S' for Sick
day, 'P' for Personal day, etc.

At the bottom you could have CountIf formulas such as...
Row 367 =COUNTIF(C2:C366,"H")
Row 368 =COUNTIF(C2:C366,"V")
Row 369 =COUNTIF(C2:C366,"S")
Row 370 =COUNTIF(C2:C366,"P")

HTH,

 

[Gord Dibben]

Andrea

Perhaps you should re-think your project.

Excel currently has 256 columns maximum, which would not allow you to place a
year's worth of dates along the top.


Gord Dibben Excel MVP

On Tue, 6 Dec 2005 09:04:04 -0800, "Andrea L" <Andrea