Detecting Someone's Age from Date of Birth

**EdWoods** · 12-18-2023, 08:05 PM

Hi

I'm trying to set up a sheet that will show someone's age (in years only) from the date of birth.

I can't make it work correctly when it's close to the birthday.

See sample attached.

Thanks, Paul

**Sam Capricci** · 12-18-2023, 08:38 PM

maybe datedif like so...
=DATEDIF(G4,G7,"y")

**EdWoods** · 12-18-2023, 08:43 PM

Originally Posted by Sam Capricci

maybe datedif like so...
=DATEDIF(G4,G7,"y")

Thanks. Seems to do the job.

I've never heard of DATEDIF before...

**HansDouwe** · 12-18-2023, 08:56 PM

Another option:

Formula:

=INT(YEARFRAC(G4,G7))

**EdWoods** · 12-18-2023, 09:08 PM

Originally Posted by HansDouwe

Another option:

Formula:

=INT(YEARFRAC(G4,G7))

Works too. Thanks.

**HansDouwe** · 12-18-2023, 09:32 PM

You are Welcome! Thanks for the feedback. Glad to have helped.

**Sam Capricci** · 12-18-2023, 11:55 PM

You're welcome, glad I could help AND thank you for the rep!
Datedif is an older formula that microsoft keeps active to support older workbooks from Lotus 1-2-3.
https://support.microsoft.com/en-us/...d-8b32a451b35c

Detecting Someone's Age from Date of Birth

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Detecting Someone's Age from Date of Birth

Re: Detecting Someone's Age from Date of Birth

Re: Detecting Someone's Age from Date of Birth

Re: Detecting Someone's Age from Date of Birth

Re: Detecting Someone's Age from Date of Birth

Re: Detecting Someone's Age from Date of Birth

Re: Detecting Someone's Age from Date of Birth

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Direct formula to looking for data according date of birth and report date

[SOLVED] Calculate Seniority Number Based on Date Of Birth and Date of Joining

Formula for calculating the date a person will be a certain date from their date of birth

Work out Term of Birth by Date of Birth

Formulas Calculating Age based on Date of Birth & Date of Death

How to find the date of retirement if date of birth is 1-April-1980

Converting Date of Birth to 'Term of Birth'

Bookmarks

Bookmarks

Posting Permissions