Kutools For Excel | How To Calculate Annual Leave In Excel ?

Here is Kutools For Excel | How To Calculate Annual Leave In Excel ?

In general, when staff have been working in a company for a year, they will deserve their annual leaves. And maybe the days of annual leave will be added with the working years. But if there are hundreds or thousands of staff in your company, how could you quickly calculate their own annual leaves. Now I tell you a formula to quickly calculate the annual leave in Excel.

Required Data Entry Operator ? : https://www.fiverr.com/share/pk8x4l

Formula : =LOOKUP(DATEDIF(B2,NOW(),"Y"),{0,"less than 1 year";1,5;10,10;20,15})

Download #Kutools :

Download Kutools For Excel : https://bit.ly/3Ccxr91
Download Kutools for Outlook : https://bit.ly/3nubrm2
Download Kutools for Word : https://bit.ly/3zhtHRD
Download Office Tab + Kutools for Excel / Outlook / Word : https://bit.ly/3EmC4z4

More Download links :

Buy Excel 2019 All-In-One: Master The New Features Of Excel 2019 / Office 365 Paperback Book : https://amzn.to/2Yx5vOR

Buy Excel 365 - Formulas, Charts And PivotTables: Supports Excel 2010, 2013, 2016 and 2019 (Excel 365 - Level 2) Paperback : https://amzn.to/3kXymD9

Buy Microsoft 365 Personal Eddition : https://amzn.to/3kNNlQc

Our Social Media Link :
► Facebook Page : https://www.facebook.com/quizziin
► Instagram : https://www.instagram.com/quizziin/
► Reddit : https://www.reddit.com/r/quizziin/
► Skyrock : https://quizziin.skyrock.com/

#KutoolsForExcel
#KutoolsForWord