Convert Years to Years/Months/Days

C

coreymartin

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
 
B

Bob Phillips

Just multiply your result by 360?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
J

JE McGimpsey

One way:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert an integer to # of years-months-days 4
Convert months to years/months 3
How do I convert a number into years and months if the numberrepresents months? 5
Counting years 2
Return Value Based on Two Others 1
monthly to full years 1
converting days to years & months & days 4
Excel Formula for years and months 2

Top