11/08/2026
HR teams handle a wide range of data every day, from employee records and leave balances to payroll reports and performance tracking. Knowing the right Excel formulas can help you save time, reduce manual work, and improve accuracy.
Here are five formulas every HR professional should have in their toolkit:
✅ XLOOKUP - Quickly find employee information such as department, manager, or salary from another worksheet.
Example: =XLOOKUP(A2,EmployeeID,Department,"Not Found")
✅ IF - Automate decisions, such as identifying employees who have completed probation or are eligible for benefits.
Example: =IF(D2>=90,"Eligible","Not Yet")
✅ COUNTIF - Count employees who meet a specific condition, like those in a particular department or employment status.
Example: =COUNTIF(B:B,"Full-Time")
✅ NETWORKDAYS - Calculate the number of working days between two dates, perfect for leave tracking or onboarding timelines.
Example: =NETWORKDAYS(StartDate,EndDate,Holidays)
✅ TEXT – Format dates consistently for reports, contracts, or employee communications.
Example: =TEXT(A2,"dd mmm yyyy")
Small Excel skills can make a big difference in your daily HR workflow.
Looking to build your Excel confidence? Join one of our upcoming Microsoft Excel training courses and learn practical techniques you can apply from day one.
