calculating Months from days!!

[meus]

Hi friends!!
I have a problem here. what i was trying to do was to calculate the months or year from the supplied days. We know that there are 365 days.
Suppose that the supplied day is 335. Then i want to know the number of month from the supplied date. My desired result is 11 (11th month from the supplied day).
How can we do that??
Attached file here:

[djapigo]

Try this...

=DATEDIF(D8,E8,"m")

[meus]

Thanks buddy.....

[djapigo]

No problem... hope it helped...

[Crooza]

In your spreadsheet you have a note saying that dividing by 365 gives you 0.9'but you want to show as 0.11 representing 11 months.

Firstly dividing by 365 will give you 0.9 years. Multiply by 12 to convert to months or simply divide the number of days by 30 to get the number of months noting that months vary in the number of days so this will be an approximation. Did you really want it to show as 0.11 though? If so you'll need to divide again by 100.

[meus]

Hi djapigo, is there any way that for month it shows upto 11 and if it increases after that, it shows 1.1 years for 13 months or so on??

[djapigo]

If you just want decimal representation, then just use =DATEDIF(D8,E8,"m")/12

But if you like something fancier, but uglier... try this...
It's ugly, but try this...

=TRIM(IF(DATEDIF(D8,E8,"y")>0,DATEDIF(D8,E8,"y")&IF(DATEDIF(D8,E8,"y")=1," year"," years"),"")&" "&IF(MOD(DATEDIF(D8,E8,"m"),12)>0,MOD(DATEDIF(D8,E8,"m"),12)&IF(MOD(DATEDIF(D8,E8,"m"),12)=1," month"," months"),""))

Let me know what you think...

BTW - thank you for the rep!