Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Cheltenham, Gloucestershire, England
    Thanked 0 Times in 0 Posts

    update figs from 1 Jan after 4th anniversary (2003)

    On 1st of Jan following the 4th anniversary of the date of joining our company you get 1 day extra holiday (25 to 26); 8th anniversary you get another (26 to 27); 12th anniversary you get a third (27 to 28)
    Therefore, if I joined on 28/02/05 the 4th anniversary will be 28/02/09 my holiday entitlement will go up to 26 on 01/01/2010 to 27 on 01/01/2014 and to 28 on 01/01/2018.
    My spreadsheet has joining dates in Col B and I would like to display correct current holiday entitlement in Col C
    If it was just on the 4th, 8th or 12th anniversary of joining it would be fine but I cannot work out how to automatically display the correct holiday entitlement from the following Jan 1st?


  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: update figs from 1 Jan after 4th anniversary (2003)

    Would you like to display the holiday entitlement for the current year? I.e. in your example, you'd see 25 today, but if it were July 2010, you'd see 26?
    If so, you can use


    in cell B2 and fill down.

Posting Permissions

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