Lab › Dates & Times › Age from Date of Birth
Age from Date of Birth: Excel Lab
Lab 19 · IntermediateDATEDIF$ absolute reference
The task: Find each person's age in full years, as on 1 October 2026.
1 Watch how it is done
Step 1: Full years between two dates
=DATEDIF(B4,$E$4,"y")- Click C4.
- Type =DATEDIF(B4,$E$4,"y") and press Enter.
- "y" means full years. Use TODAY() instead of $E$4 for today's age.
- Drag the fill handle down.
2 Your turn
Download the practice file. It has new numbers. Open it in Excel (or Google Sheets) and do the same steps.
3 Check your answers
Stuck? Download the solution file and compare it with yours.
Next lab: Library Late Fee →
Want the theory? Read the Dates & Times lessons →
← More Dates & Times labs · All lab categories
