On Tue, 24 May 2005 19:28:23 GMT, "Dave Cobb" wrote:

I want to convert the number of days in a cell (ie: 2350) to Xyears and
Ymonths. What formula to use?

Thanks,
Dave


You will need to define exactly what *you* mean by "years" and "months".

A year can have 365 or 366 days; and a month can have 28,29,30 or 31 days.

You could arbitrarily set a year at 365.25 days; and a month as 30 days, and
use the formula:

You could then use the formulas:

Years: =INT(N1/365.25)
and Days: =ROUND(MOD(N1,365.25),0)

But there are many other possible solutions.


--ron