[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


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

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

[David Biddulph[_2_]]

=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

[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


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

[ed]

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