Rounding the months and days in between 2 dates

mart_mrexcel

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

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

Tetra201

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

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

Watch MrExcel Video

Forum statistics

Threads
1,099,794
Messages
5,470,825
Members
406,727
Latest member
Kimze

This Week's Hot Topics

Top