Hi

I am having age of a person. I want to know his DOB.
Format Like this.

If today is 2-Feb-1996 and age of any person on that date is 10 yrs. 6 months and 19 days
what was that person's Date of Birth ?

---

Richard Replies:

Use the DATE() function, such as:

=DATE(YEAR(A1)-10, MONTH(A1)-6, DAY(A1)-19)

See this tutorial on dates in Excel for additional explanation.