Age Calculation
 

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

Age Calculation
 

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


Replace @mailinator.com with @tiscali.co.uk


"Cathy" wrote in message
...
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

Age Calculation
 

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


"Cathy" wrote:

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

Age Calculation
 

=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.
--
David Biddulph

"Cathy" wrote in message
...
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

Age Calculation
 

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


Replace @mailinator.com with @tiscali.co.uk


"Sandy Mann" wrote in message
...
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


Replace @mailinator.com with @tiscali.co.uk


"Cathy" wrote in message
...
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

Age Calculation
 

On Jun 11, 4:10*pm, Kevin B wrote:
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



"Cathy" wrote:
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- Hide quoted text -

- 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