Age from date of birth
Work out each person's age in years from the birth dates in column B, in column C.
Changes data. A backup copy and an undo point are turned on.
What it does, step by step
- Write “Age” in C1
- Age formula in C2:C1000
Use it in MacroRoni: open the Starter gallery, search for "Age from date of birth", check the steps, and adjust the sheet and ranges to fit your workbook. Preview the result before you run it.
More dates & time macros
Dates & timeDays until dueCount the days from today until each due date in column C, in column D.Changes data · backup onDates & timeDays overdueShow how many days each due date in column C is late (0 if not late), in column D.Changes data · backup onDates & timeMonth name from a dateWrite the month (January, February…) of each date in column A into column B.Changes data · backup on