Formula To Calculate Accrued Time With Variables

  • Hello!


    I need some help with a formula that will calculate sick time earned starting on the employee's anniversary date (cell J11). The employee will accrue 4 hours every 30 days, but will not earn more than 48 hours in 12 consecutive months. I'm afraid this is beyond my ability so any help is much appreciated. I've attached the workbook.

  • Is it not just:


    =MIN(48,INT((TODAY()-J11)/30)*4)


    assuming you only get the 4 days when you've actually done each 30 days, rather than earning fractions each day.

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why