Vacation Tracking.

Sir,

I got a requirement to develop something in excel 2007 to track vacation of employees. details are given below:

1. Total # of employees = Approx. 200
2. Year Start = Jan-01-20xx
3. Number of Vacation/year = 30 days

I want to track Balance vacation plus planned vs actual comparison. I prefer to have dashboard.

Kindly Advice urgently.

Qayyum

What have you got so far?

Do you mean about the employee data. I have all the necessary information available like detail of employee, total vacation and balance days.

I mean attach an example of what you have tried and containing dummy data

You could do something simple like
A1 , employee name
B1 , total days available per year
C1 , actual remaining
D1 , planned rmaining
E1-?1 , vacation dates

A2 , employee
B2 , 30
C2 , =B2-COUNTIF(E2:K2,"<="&TODAY())
D2 , =B2-COUNT(E2:AA2)
E2 , 1/3/2013
F2 , 2/2/2013
G2 , 5/5/2013