I have a cell which contains a DOB (11.02.93) and I wish in...

FAQS.ORG makes no guarantees as to the accuracy of the posts. Each post is the personal opinion of the poster. These posts are not intended to substitute for medical, tax, legal, investment, accounting, or other professional advice. FAQS.ORG does not endorse any opinion or any product or service mentioned mentioned in these posts.

<< Back to general questions

[ Home | FAQ-Related Q&As | General Q&As | Answered Questions ]

Question by mbonfyre
Submitted on 9/19/2003
Related FAQ: N/A
Rating: Not yet rated	Rate this question:
I have a cell which contains a DOB (11.02.93) and I wish in anoyther cell to be able to calculate the age on a given date (31.08.03). I have been playing with formulas to try to get what to do but keep getting 'VALUE!'. Can anyone help pplease?

Answer by Goddess
Submitted on 10/18/2003
Rating: Not yet rated	Rate this answer:
Set the cell format of your "date" cells to "date." Do not use a period as a separator. Use a slash (/) or a dash (-). in the cell that you want an answer, use a formula such as: =(cell containing today's date)-(cell containing beginning date)/365. The answer will be in the number of years and does not account for leap years. The slash indicates "divide". If you want months, then use 30 instead of 365.

Your name or nickname:
If you'd like to create a new account or access your existing account, put in your password here:
Your answer: