• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Calculate agr from number of Year (i.e 29)

Juniad

Juniad

Active Member
Hello please help me out, I want to calculate the age from number of year, like if someone ask me i am 29 year old, so how to calculate exact date of birth from today date to 29 year back ,answer should be in dd/mm/yyyy.
 
If you have the Age in years in A1, you can use:
=EDATE(TODAY(),-A1*12)

And adjust the format in "dd/mm/yyyy" (custom format).

Blessings![/quote]

What its mean of minus (-A1*12)
 
Your requirement is unclear. If I say I'm 30 today, it does not mean that today is my anniversary , so how would one fine my exact birth date?
The NUM error is probably due to the fact A1 is not a number or a real date but text looking like a date
 
You must log in or register to reply here.
Back
Top