Results 1 to 5 of 5

Thread: Vacation Tracking.

  1. #1

    Question Vacation Tracking.



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Conjurer royUK's Avatar
    Join Date
    Mar 2011
    Location
    Derbyshire, UK
    Posts
    155
    Articles
    0
    Excel Version
    most versions
    What have you got so far?
    Hope that helps

    Roy

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

  4. #4
    Conjurer royUK's Avatar
    Join Date
    Mar 2011
    Location
    Derbyshire, UK
    Posts
    155
    Articles
    0
    Excel Version
    most versions
    I mean attach an example of what you have tried and containing dummy data
    Hope that helps

    Roy

  5. #5
    Conjurer Simi's Avatar
    Join Date
    Feb 2012
    Location
    Utah, USA
    Posts
    187
    Articles
    0
    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

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •