Excel age calculator

Marty999

I have a spreadsheet containing a list of members for my organisation, and their dates of birth in the format 18/12/2009 etc. Please could someone advise me of a quick and easy way to display their ages too? I only really need whole years but fractions would be OK. Thanks...

jessicamb

Marty999 wrote: »

I have a spreadsheet containing a list of members for my organisation, and their dates of birth in the format 18/12/2009 etc. Please could someone advise me of a quick and easy way to display their ages too? I only really need whole years but fractions would be OK. Thanks...

=today()-your date field

then format the cell to custom YY

Marty999

Hi Jessicamb
It is coming up with #NAME?

Not sure what this means?

jessicamb

Marty999 wrote: »

Hi Jessicamb
It is coming up with #NAME?

Not sure what this means?

hmm worked ok for me when I tried it. What is your formula exactly? What is the cell format for the date cell set at?

Marty999

My formula is =today-(M3) (cell M3 contains the first person's date of birth)

The format of this cell is Number/Categoy = Date
and Type = 14/03/2001

jessicamb

Marty999 wrote: »

My formula is =today-(M3) (cell M3 contains the first person's date of birth)

The format of this cell is Number/Categoy = Date
and Type = 14/03/2001

Try this:

=today()-M3 and then format the cell if needed to YY

Marty999

That's done the trick!

Many thanks Jessi. :beer:

jessicamb

Marty999 wrote: »

That's done the trick!

Many thanks Jessi. :beer:

You're welcome. One last thing - if you are using the spreadsheet over any length of time then that formula will update each time you use the spreadsheet. If you need it to stay constant for any reason then you might want to copy and paste special/values a version of the sheet.

Stompa

jessicamb wrote: »

Try this:

=today()-M3 and then format the cell if needed to YY

That's not 100% accurate though, and can be a year out around the time of a birthday.

Try: =DATEDIF(M3,TODAY(),"Y")