Administration and Executive AssistantTier 720 minintermediate

DATEDIF Argument Order

Calculate an employee's tenure in complete years, keeping the earlier date first.

What you will learn

• Use DATEDIF to calculate a whole number of complete years between two dates
• Explain why DATEDIF's first argument must be the earlier date
• Recognise that reversing the two dates does not give a negative answer - it gives #NUM!

Excel skills

DATEDIF · Date Calculations

The task

Ten employees' hire dates are listed. Work out each one's tenure in complete years as of the date in Summary!B3, in column C.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free