Age Calculation

[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

 

[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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[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)

 

[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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[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 -

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