Convert Years to Years/Months/Days

Through a calculation, I get an amount of time in years (ex. 1.31
years). How would I convert that number to years/months/days based on
a 360 day year?

Thanks!
Corey

Also, for our purposes, a month is always 30 days.

Just multiply your result by 360?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

<coreymartin@gmail.com> wrote in message
news:1136384291.470002.53750@z14g2000cwz.googlegroups.com...
> Also, for our purposes, a month is always 30 days.
>

Look in HELP for the DAYS360() function

--
Kind regards,

Niek Otten

<coreymartin@gmail.com> wrote in message
news:1136384291.470002.53750@z14g2000cwz.googlegroups.com...
> Also, for our purposes, a month is always 30 days.
>

One way:

=INT(A1) & " years, " & INT(MOD(A1,1)*12) & " months, " &
MOD(A1*360,30) & " days"


In article <1136384008.789107.264760@o13g2000cwo.googlegroups.com>,
coreymartin@gmail.com wrote:

> Through a calculation, I get an amount of time in years (ex. 1.31
> years). How would I convert that number to years/months/days based on
> a 360 day year?