Excel Functions for HR Professionals

by | Oct 31, 2017

Human Resource Professionals have a hectic schedule. They deal with benefits, training, staffing, retention, reviews, hiring, firing, personnel manuals, and many other HR aspects of their jobs.

I’ve put together a list of Excel functions every HR Professional should know. This list is not all inclusive but comes from questions asked to me by HR Professionals over the years.


Video on Excel HR Functions

Video Bookmarks:

  • 00:15 Today Function
  • 00:45 Datedif Function
  • 04:00 Networkdays Function
  • 06:10 Workday Function

Today Function

=today()

This is one of my favorite functions in Excel. The Today function calculates the current date from your computer and will update automatically. If today was October 15, 2017, the today function will return 11/3/2017. Tomorrow it will automatically update to 11/4/2017.

Examples of when to use today:

  1. Calculate the ages of employees.
  2. Calculate an employees length of service
  3. Calculate days overdue when an HR form was supposed to be submitted.

DatedIf Function

=datedif(start_date, end_date, Unit)

Calculates the number of days, months, or years between two dates.

Datedif function by Chris Menard

  • Y is years
  • M is months
  • D is days
  • MD is days ignoring months and years
  • YM is months ignoring years
  • MD is days ignoring years and months
chris menard on Linkedinchris menard on Youtube
chris menard
Microsoft Office Master Instructor
I train corporate clients in Microsoft Office Excel, PowerPoint, Word, and Outlook. When I'm not training, I blog about technology and create training videos on YouTube. I currently have over 240 technology videos available. Most of the videos I've created come from questions asked during MS Office training.

Pin It on Pinterest