Hi,

Here is one solution

=YEARFRAC(--"1/1/09",--"1/1/09"+750,1)

An alternative is to use the DATEDIF function, and since you didn't give us
a starting date:

=DATEDIF(--"1/1/09",--"1/1/09"+750,"Y") whole years
=DATEDIF(--"1/1/09",--"1/1/09"+750,"YM") whole months left over
=DATEDIF(--"1/1/09",--"1/1/09"+750,"MD") days left over


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"wrong way carrigan" wrote:

Number of Years
Balance of days in Months
then days left