Solved: Divide number of days

[austenr]

Is there a formula that can divide a certain number of days by 365 and you are left with the remainder of so many days. For example, 400 days in A1 would come out as "1 year 35 days" assuming that there are 365 days in a year. Thanks

[Bob Phillips]

Is there a formula that can divide a certain number of days by 365 and you are left with the remainder of so many days. For example, 400 days in A1 would come out as "1 year 35 days" assuming that there are 365 days in a year. Thanks

This is basic math Austen http://vbaexpress.com/forum/images/smilies/001.gif

=INT(A10/365)&" Year, "&MOD(A10,365)&" days"

[austenr]

Oh yea. Too late in the day to think of that. Besides I would have to take my shoes off to calculate it. Not a pretty site. :devil:

[austenr]

Thanks, X