Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Aug 2006
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Complex problem (excel 2000)

    Dear Excel Experts,

    I created a spreadsheet to keep track of annual leave and other absenteeism for around 30 employees. For annual leave I have created a column to work out the pro- rata leave for each employee. What I mean by that is for example an employee is entitled to 20 days annual leave a Datedif formula works out the number of days that have elapsed since the anniversary date when the employee started work and today

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Complex problem (excel 2000)

    Why not calculate the pro-rata leave from the start of employment date instead of from the most recent anniversary? So if an employee started on January 11, 2005, accumulated leave today (July 11, 2007) would be 2.5 * 20 = 50 days.

  3. #3
    New Lounger
    Join Date
    Aug 2006
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Complex problem (excel 2000)

    Thank you Hans. I will do it that way

Posting Permissions

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