Home » Forums » Open Source Learning Center » Question and Answer

Formula For Calculating PTO Days

Submitted by mshelnut on 26 May, 2015 - 15:58

In excel, I need a cell to calculate the following formula for my paid time off spread sheet.
Earn 1 day per year for years 1 and two
Earn 2 days per year for every year after.

Thanks for any help you can give.

‹ Vlookup with If or Index Match? HELP!! Corrupted Microsoft Excel Macro-Enabled Workbook xlsm file ›
»

Here goes

Submitted by Jon on 26 May, 2015 - 20:01.

assuming your date is in A1

=IF(DATEDIF(A1,TODAY(),"y")=1,1,IF(DATEDIF(A1,TODAY(),"y")=2,2, 2+ (DATEDIF(A1,TODAY(),"y")-2)*2))

Hope this helps

»