DATEDIF
AdvancedExpert
10 questions, about 18 minutes
Work out an age in whole years, even though the function isn't in Excel's list.
What we'll do
- Working out whole years and months
- The units Y, M and D
What you'll use
DATEDIFTODAY
How it works
In an example you watch and don't need to fill anything in. You answer a question yourself. If it goes wrong, you get a tip, then a hint and finally the solution.
2examplesYou watch
10questionsYou do it yourself