Can anyone please help. What I am trying to does this. I am working on a family birthday reminder spreadsheet. I know everyone's date of birth. I will have the names in column 1 and in the next column 2 would be their date of birthday. What I want to be able to do is to be able to open the spreadsheet and be able to view in the next column 3, their current age in years so I know what birthday card to buy.
MacBook, macOS 10.14
Hi T_A_M,
Use TODAY to get today's date and DATEDIF to determine the number of years since the person was born.
Here's an example for two people born shortly before and shortly after today's date in 2000:
The formula shown is entered in C2, and filled down to C3. "Y" is chosen from a menu opened by clicking the disclosure triangle on the token.
The description for DATEDIF in the Function Browser will give you information on the other 'codes' which may be placed in the position, and the effect of each.
In column B, both cells have this formula:
Which returns today's date,
Regards,
Barry
Hi T_A_M,
Use TODAY to get today's date and DATEDIF to determine the number of years since the person was born.
Here's an example for two people born shortly before and shortly after today's date in 2000:
The formula shown is entered in C2, and filled down to C3. "Y" is chosen from a menu opened by clicking the disclosure triangle on the token.
The description for DATEDIF in the Function Browser will give you information on the other 'codes' which may be placed in the position, and the effect of each.
In column B, both cells have this formula:
Which returns today's date,
Regards,
Barry
Thank you, Barry.
I'm an older person, a "silver surfer", with an extended family, very little experience of spreadsheets and learning as I go.
Your reply is perfect, exactly what I needed.
Thank you so much.
Regards
T_A_M
HI T_A_M,
One thing I should have added…
Like all formulas in Numbers, this one will update only when there is a change in the table.
The change could be entering a new birthdate, or could be as simple as checking or unchecking a checkbox.
You can put a checkbox in any unused cell on the table, or in a case like this one, you could add a column and set the Data format of one of the cells in that column to Checkbox. Clicking the box would then update the calculations on the table.
Regards,
Barry
Formula to work out someone's age in years at today's date.
