formula to calculate age
I would like to set up a spreadsheet for birthdays; so the formula would calculate someone's age based on birth date and current date
Sorry, that was:
= DATEDIF(A1,TODAY(),"Y")
4 replies
You could use the following formula:
= (A1,TODAY(),"Y")
Where cell A1 is the cell containing the birthday.
Source: How can I calculate an age in Numbers? - Apple Community.
Thank you, that worked perfectly!
Great! You are welcome!
formula to calculate age