Practice / Dates

Difficulty 3 of 5 · about 3 min

Count complete months of service with DATEDIF

Column B has each employee's joining date and column C has the date the service report is run as of. In D2, write a formula that returns the number of complete months between the joining date in B2 and the as-of date in C2. A part month does not count.

Loading grid…