Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
calculate age formula

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Calculate age formula

Calculate age formula

ResolvedVersion 2003

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

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:

Jumping Between Sheets in a Book

PgDn and PgUp keys scrolls up and down a screen page in most applications.

Ctrl+PgDn and Ctrl+PgUp keys jump from one sheet in your workbook to the next, up or down through the pages.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.08 secs.