Age Calculation

C

Cathy

In column A i have a date 05/08/1966 in column B I have another date
12/31/2008. In column C I need that difference to appear as 42.58 (that
number is only an example of how I need it to appear)

Thank you in advance for your help.

Cathy
 
S

Sandy Mann

The simple answer is:

=(A2-A1)/365

With theDOB in A1 or:

=ROUND((A2-A1)/365,2)

if you want to limit the number of digits

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
K

Kevin B

The following formula will give you 42.68, not 42.58, but I thought the .58
might be a typo:

=ROUND((B1-A1)/365,2)
 
D

David Biddulph

=DATEDIF(A1,B1,"y")+DATEDIF(A1,B1,"yd")/365.24
Adjust the formula as you think fit to decide how you want to define the
proportion of a year.
 
S

Sandy Mann

My simple answer is too simple, it ignores that fact that there are leap
years in the intervening years. I would recommend that you go with David
Biddulph's answer.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
E

ed

The following formula will give you 42.68, not 42.58, but I thought the .58
might be a typo:

=ROUND((B1-A1)/365,2)
--
Kevin Backmann







- Show quoted text -
Click to expand...

Type =YEARFRAC(A1,B1,1) in cell C1 and copy down column C to the
end of the dates. This gives 42.65 as an answer and is correct
regardless that the difference might contain leap years. Anything
containing /365 either ignors leap years or might not adjust
correctly depending on the specific years in the difference.

ed
 
Top