Calculating age using two dates (one yyyy, the other mm/dd/yyyy)

**msmth** · 03-10-2017, 05:37 PM

Is there a function that would allow me to calculate a person's age if only the year was given for their date of birth? Obviously it would only come out (mm/dd/yyyy - birth year) or (mm/dd/yyyy - birth year)-1. I want the outcome to be in that range if possible, example (06/01/1990 - 1950) = Age 39-40.

Thanks for your time.

**TMS** · 03-10-2017, 05:54 PM

Formula:

Please Login or Register  to view this content.

or, if you name the ranges A2 and B2 as date and birthyear respectively:

Formula:

Please Login or Register  to view this content.

will return: 39 to 40

**daddylonglegs** · 03-10-2017, 05:55 PM

If you have the year of birth in A1 try this formula for age today

=YEAR(TODAY())-A1

**Amanda Wilso** · 03-10-2017, 05:58 PM

Let’s refer to article in the following thread which discusses about a similar and see if it helps: http://excelhints.com/2011/08/02/cal...-age-in-excel/

**msmth** · 03-13-2017, 12:34 PM

Thanks all for your input. It was much appreciated!

**TMS** · 03-13-2017, 01:10 PM

You're welcome. Thanks for the rep.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

Calculating age using two dates (one yyyy, the other mm/dd/yyyy)

LinkBack

Thread Tools

Rate This Thread

Display

Calculating age using two dates (one yyyy, the other mm/dd/yyyy)

Re: Calculating age using two dates (one yyyy, the other mm/dd/yyyy)

Re: Calculating age using two dates (one yyyy, the other mm/dd/yyyy)

Re: Calculating age using two dates (one yyyy, the other mm/dd/yyyy)

Re: Calculating age using two dates (one yyyy, the other mm/dd/yyyy)

Re: Calculating age using two dates (one yyyy, the other mm/dd/yyyy)

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] counting unique dates switched from HH:MM:DD DD/MM/YYYY to DD/MM/YYYY HH:MM:DD

Converting dates: YYYY-MM-DD into DD Month YYYY

[SOLVED] VBA incorrectly changing some dates from DD/MM/YYYY to YYYY-DD-MM

[SOLVED] Converting dates from dd/mm/yyyy to mm/dd/yyyy

Dates - copy+paste - unwanted dd/mm/yyyy to mm/dd/yyyy format

Copy+Paste macro dd/mm/yyyy to dd/mm/yyyy and NOT dd/mm/yyyy to mm/dd/yyyy

Macro to convert dates format from yyyy mm dd to yyyy-mm-dd

Bookmarks

Bookmarks

Posting Permissions