Rounding the months and days in between 2 dates

[mart_mrexcel]

I'm calculating number of months and days in between 2 dates (jan1 2019 & Dec 31, 2019) using a formula Value(Datedif(A1,B1,"M")&"."&datedif(a1,b1,"md")+1) and i am getting a result of 11.31 but i wanted to appear as 12 instead (since 31 completes the whole month).

I want to get the real Number of months and day. example in between Jan 28 2019 to Dec 31 2019, id like to have a result o 11.04 days

 

[Tetra201]

Maybe

=VALUE(DATEDIF(A2,B2+1,"M")&"."&TEXT(DATEDIF(A2,B2+1,"md"),"00"))

 

[mart_mrexcel]

Maybe

=VALUE(DATEDIF(A2,B2+1,"M")&"."&TEXT(DATEDIF(A2,B2+1,"md"),"00"))

Thanks that works perfectly. have a great day ahead