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,442
Maybe

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

Forum statistics

Threads
1,077,855
Messages
5,336,790
Members
399,102
Latest member
chudson1

Some videos you may like

This Week's Hot Topics

Top