Excel Functions for HR Professionals

Posted on:  10/31/2017 Excel Functions for HR Professionals

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.

Calculate nr of days, months or years between dates

  • 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

Chris Menard is a Microsoft Certified Trainer (MCT) and Microsoft Most Valuable Professional (MVP). Chris works as a Senior Trainer at BakerHostetler - one of the largest law firms in the US. Chris runs a YouTube channel featuring over 900 technology videos that cover various apps, including Excel, Word, PowerPoint, Zoom, Teams, Coilot, and Outlook. To date, the channel has had over 25 million views. Menard also participates in 2 to 3 public speaking events annually, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.

Categories