Formula For Calculating PTO Days
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.
ExcelExperts.comExcel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 |
|
Excel / VBA ConsultancyFree Training VideosFree SpreadsheetsExcel / VBA JobsNavigationWho's onlineThere are currently 0 users and 415 guests online.
New Excel Experts
Current Excel / VBA Jobs |
Formula For Calculating PTO DaysIn excel, I need a cell to calculate the following formula for my paid time off spread sheet. Thanks for any help you can give. |
Highest Ranked Users
Recent Blogs
ForumsRecent comments
User login |
Here goes
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