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

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Tetra201

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

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

Watch MrExcel Video

Forum statistics

Threads
1,090,120
Messages
5,412,562
Members
403,433
Latest member
DavidCB

This Week's Hot Topics

Top