How do I find out date of birth from an age?

L

louis.s.buck

I have a person's age in one column, and in the next I would like a
formula to show to when that person was born (obviously the <i>year</
i> when that person was born, not exact date).
There's either a really simple answer or a really long answer! either
way I can't find it anywhere! It must be a case of simply taking the
'age' away from the 'current date'.. but hooow! Please help,
thankyou.
 
N

Niek Otten

=DATE(YEAR(TODAY())-A1,1,1)
Format as yyyy

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a person's age in one column, and in the next I would like a
| formula to show to when that person was born (obviously the <i>year</
| i> when that person was born, not exact date).
| There's either a really simple answer or a really long answer! either
| way I can't find it anywhere! It must be a case of simply taking the
| 'age' away from the 'current date'.. but hooow! Please help,
| thankyou.
 
S

Sandy Mann

To the OP:

Note that the *year* will depend on whether or not the person has had their
birthday this year or not, ie if they have not had their birthday yet you
will have to subtact 1:

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
S

Stefi

Yes, that's true. I think the data provider should define that a person's age
is, say 40 if his/her 40th birthday is within that year!

Regards,
Stefi

„Sandy Mann†ezt írta:
 
S

Sandy Mann

Note that the *year* will depend on whether or not the person has had
And perhaps I should have been more specific in that I meant you had to
subtract 1 from your formula result *NOT* the person's age!

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating age from date of birth and ignoring if blank 5
"how do I calculate age by using date of birth details" 5
calculate date of birth with an end date and age 1
Count/Calculation According to Age of the Person 1
Birthday Calculations 1
Accumulating Attendance Base upon Age Group 5
How do I find age in years from anniversary date (Age funtion)? 1
How do I calculate a persn's age in years & months in Excel? 4

Top