Calculate age formula

Resolved · Medium Priority · Version 2003

Fri 7 Oct 2011, 13:28 Delegate Joan said...

Joan has attended:
Excel Introduction course

Calculate age formula

How do I enter date of birth, then find age at various dates from today onwards

Fri 7 Oct 2011, 14:48 Trainer Paul said...

RE: Calculate age formula

Hi Joan

Enter your date of birth into cell A1 in this format 00/00/0000, replace the 0 with your actual DOB

In cell A2 enter a future date.

In cell A3 enter this formula =A2-A1

In cell A4 enter this formula =A3/365.25

You can now enter any date into cell A2 and excel will calculate your age at that given date.

Does that help?

Kind Regards
Paul

Excel tip:

Printing spreadsheets without opening them first

Here's a fast way of printing a spreadsheet from Windows Explorer/My Computer.

Go to the location where the spreadsheet is saved on your computer, then right-click on the icon next to the document and select Print from the menu.

The spreadsheet will automatically open, print and close itself.

View all Excel hints and tips

Calculate age formula

Calculate age formula

RE: Calculate age formula

Excel articles

Excel tip:

Printing spreadsheets without opening them first