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

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 iyear/
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.

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in message ...
|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 iyear/
| 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.

Age being in A1
=YEAR(TODAY())-A1
Regards,
Stefi

â€� ezt Ã*rta:

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 iyear/
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.

Brilliant, thankyou so much!

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


Replace @mailinator.com with @tiscali.co.uk


"Stefi" wrote in message
...
Age being in A1
=YEAR(TODAY())-A1
Regards,
Stefi

" ezt írta:

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 iyear/
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.

You are welcome! Thanks for the feedback!
Stefi

â€� ezt Ã*rta:

Brilliant, thankyou so much!

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:

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


Replace @mailinator.com with @tiscali.co.uk


"Stefi" wrote in message
...
Age being in A1
=YEAR(TODAY())-A1
Regards,
Stefi

" ezt Ã*rta:

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 iyear/
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.

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:

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


Replace @mailinator.com with @tiscali.co.uk


"Stefi" wrote in message
news
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:

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


Replace @mailinator.com with @tiscali.co.uk


"Stefi" wrote in message
...
Age being in A1
=YEAR(TODAY())-A1
Regards,
Stefi

" ezt írta:

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 iyear/
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.

Okay, thanks for your advice. You've all helped a lot!