Rounding the months and days in between 2 dates

mart_mrexcel

Board Regular
Joined
Aug 23, 2008
Messages
214
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
 
Last edited:

Tetra201

MrExcel MVP
Joined
Oct 14, 2016
Messages
3,437
Maybe

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

Forum statistics

Threads
1,077,736
Messages
5,335,903
Members
399,056
Latest member
CityGirlLuv

Some videos you may like

This Week's Hot Topics

Top