PDA

View Full Version : Solved: Divide number of days



austenr
11-02-2005, 04:19 PM
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
11-02-2005, 04:23 PM
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
11-02-2005, 04:28 PM
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
11-02-2005, 04:32 PM
Thanks, X