IntermediateHRAbout 6 minutes
Sample data
| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Name | Department | Salary | Start date | Rating |
| 2 | Amira Hassan | Finance | 9200 | 2019-03-04 | 4 |
| 3 | Ben Carter | Sales | 7800 | 2021-07-19 | 3 |
| 4 | Chen Wei | Sales | 8100 | 2020-01-13 | 5 |
| 5 | Dina Ali | HR | 7200 | 2022-09-01 | 4 |
| 6 | Emil Novak | Operations | 6900 | 2018-11-26 | 2 |
| 7 | Farah Khan | Finance | 10400 | 2016-05-09 | 5 |
| 8 | Gabriel Silva | Operations | 6500 | 2023-02-14 | 3 |
Steps
Each formula is already filled in and calculated. Edit it and press Run to try your own version. Nothing is saved or uploaded.
Whole years of service up to 31 Dec 2025 for Amira.
Result
Months left over after the whole years.
Result
Probation end: six months after the start date for Gabriel.
Result
Working days between two dates.
Result
Join years and months into one sentence.
Result
What to remember
DATEDIF counts complete years, months or days. Use a fixed report date (not TODAY) when the report must not change.
Formulas used
Need Something Different? Let’s Talk.
Looking for different features or something built around your workflow? Share your idea with us.