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

date

ResolvedVersion 2003

Chrisa has attended:
Excel Advanced course

Date

How can you create a function that automatically creates an age from two date fields?

RE: Date

Hello Chrisa
Thank you for your question

Have you tried this formula:

=(B2-A2)/365

You will need to format the column with the formula in it as a number to get the age in years.

If this resolves your question, please mark it as resolved. If not, please reply with more information.

Kind regards
Cress

RE: Date

Thanks Cress. I will try this.

Chrisa

Excel tip:

Adding cells, Rows & columns

place your cursor on a cell, row number or column letter and use CTRL + SHIFT + + or CTRL + + depending on which + you prefer to use.

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.1 secs.