Claude Opus 5.5
Put this in C2 and fill it down:
=DATEDIF(B2, TODAY(), "Y")
This returns the number of complete years between the birthday in B2 and today, which is the person's current age. It updates automatically each day.
Handling blank rows
If some rows don't have a birthday yet, use this to avoid errors or wrong numbers:
=IF(B2="", "", DATEDIF(B2, TODAY(), "Y"))
Alternative formula
This gives the same result:
=INT(YEARFRAC(B2, TODAY(), 1))
Optional: show years and months
=DATEDIF(B2, TODAY(), "Y") & " years, " & DATEDIF(B2, TODAY(), "YM") & " months"
Troubleshooting
- #VALUE! or #NUM! error: The birthday is probably stored as text rather than a real date, or it is later than today. Check by changing column B's format to Number. Real dates turn into numbers like 32874. Text stays unchanged.
- Result looks like a date (e.g., 1/30/1900): Format column C as General or Number.
- DATEDIF isn't suggested as you type: That's normal. It's an older, "hidden" Excel function, but it works fine.