How do I create a formula to automatically calculate ages in a spreadsheet. Fore instance, I have birthdays in rows B2-B160 and would like to have their ages automatically calculated in the column next to them (C2-C160). I am running Numbers vs 6.1 on an iMac (running High Sierra).
"…the formula in C2 and it worked for that row, but how do I get it to go down the entire column?"
Click on the last cell containing the formula, then place the pointer near the bottom border of that cell.
The yellow dot that appears in the Fill control. Place the pointer on the dot—the pointer will change to a pair of arrows pointing up and down, with a horizontal line separating then. Click and hold the mouse button and drag down to fill the formula into the rows below.
The image shows the starting position, but was taken after I had filled the cells in rows 11 to 15.
Once you have the formula filled to the bottom cell in the column, Numbers will automatically fill it into new rows added to the column (which is what actually happened in this table whenI added those five rows by dragging the Row control, seen below the row reference tab for row 15, down to add five rows.
If you have a very long column, you may find this alternate method more efficient:
Select the last cell containing the formula. Press command-C to copy the cell and its contents.
Scroll to the last cell in the column.
Chift-click (press and hold the shift key then click) on that cell.
Press command-V to Paste the formula into all selected cells.
In either case, Numbers will automatically adjust the cell reference to fit the row containing each copy of the formula.
The TODAY function returns today's date. TODAY recalculates whenever there is a change in the table containing the function.
The change can be as small as clicking a checkbox cell to change its value from FALSE to TRUE (or vice versa).
Regards,
Barry
Column b contains Sate a d time values, entered as dates in the format displayed.
C2 contains the formula shown below the table. The formula is filled down to the rest of the cells in column C.
The birthdates in Column B are real (although in some cases they are 'first publication dates' of fictional characters).
Can you complete the names?
Ages are calculated for Today (August 13, 2020
Regards,
Barry
Thank you, Barry. I input the formula in C2 and it worked for that row, but how do I get it to go down the entire column? I'm sure there is an easier way than to insert a formula in each row?
Also, since it's calculated to today, does that mean that it will refresh every day, or will I need to edit the formula occasionally?
Thank you, Barry! That worked perfectly!
Calculate ages in Numbers
