# Thread: Excel 2003 Calculating Dates

1. How can I tell how old someone is from two dates? So if I enter 1/4/1966 in A1 and enter 1/1/2010 in A2, in Cell A3 I want it to be able to tell me that I am 43...just 3 days shy of 44. I used the Year function but that does not calculate the month and day, therefore it says 44. I am sure there is an easy formula...can anyone help me?

2. Depending on the degree of precision needed, this should work .....
=INT((B2-B1)/365.25)

How accurate do you need to be?
This formula yields pretty accurate results but it isn't infallible. Dividing by the average number of days in a year works for most people most of the time, but sometimes it gets it wrong. Supposing the person in question is a child, who hasn't yet lived through a 366 day year, you should be dividing by 365 and not 365.25.

If more precision is needed, we can give a longer formula.

Here is another short formula ....
=DATEDIF(B1,B2,"y")
For some reason, Microsoft has decided not to document this function in any other versions. DATEDIF is treated as the drunk cousin of the Formula family. Excel knows it lives a happy and useful life, but will not speak of it in polite conversation.
Do not confuse the DATEDIF worksheet function with the DateDiff VBA function.

3. Here are a couple of links for DATEDIF function ....

Introduction To The DATEDIF Function

DateDif - An Excel's Age Calculator

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•