as excel has only 256 columns you'll need to show the dates down the rows so
in
A3 type
1/1/2005
(or whatever your starting date is)
hold your mouse over the bottom right of the cell until you see a + then
hold the mouse down and drag to your finishing date
Enter the employee names in cells B2 to K2
then you can fill in the sheet whenever they have holidays
to keep a count of the number of days holiday if you use something like AL
for annual leave you can use say in B2 a countif function to count the
number of days of Annual Leave for that employee
=COUNTIF(B3:B367,"AL")
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
