=(TODAY()-A1)/365

where cell A1 is the age.

Fix the decimal place to 0 on the cell you putting it into.

Posted By: Rivers_Wonderland, Aug 22, 12:24:43

Follow Ups

2
i don't have d.o.b. all in one cell
Posted By: Dave in France, Aug 22, 12:36:15
1
surely A1 is the date of birth?
Posted By: mr carra, Aug 22, 12:27:04
Corection: wehere cell A1 is the date of birth
Posted By: Rivers_Wonderland, Aug 22, 12:26:11

Reply to Message

Written & Designed By Ben Graves 1999-2025