DateDif -- nearest half date (x.5)

[xtinct2]

Hi --

I hope this is is a simple ask

what's the best way to calculate the difference b/w two dates (in # of months) with the result rounded to the nearest hals month.

So the difference between 4/15/2017 and 6/30/2017 would be 1.5 (instead of 2)

Thanks!

 

[Scott Huish]

Why would it be 1.5? That's 2.5 months difference.

If 2.5 months is correct, will this get you close enough?

=MROUND((B1-A1)/30,0.5)

 

[Trouttrap2]

You example i think should be 2.5 months not 1.5 months. In any case, you could use this.
=MROUND(DATEDIF("4/15/2017","6/28/2017","d")/30,0.5)

 

[FDibbins]

Not sure how you get 1.5, should it not be 2.5? That is 2 2 months and 15 days.

The question then becomes do you want to round up from 15 or 14 or...?
=IF(DATEDIF(A1,B1,"y")=0,"",DATEDIF(A1,B1,"y")&" years ")&IF(DATEDIF(A1,B1,"ym")=0,"",DATEDIF(A1,B1,"ym")& " ")+IF(DATEDIF(A1,B1,"md")>14,1,0.5)
Change the bolded part as needed

 

[FDibbins]

Not sure how you get 1.5, should it not be 2.5? That is 2 2 months and 15 days.

The question then becomes do you want to round up from 15 or 14 or...?
=IF(DATEDIF(A1,B1,"y")=0,"",DATEDIF(A1,B1,"y")&" years ")&IF(DATEDIF(A1,B1,"ym")=0,"",DATEDIF(A1,B1,"ym")& " ")+IF(DATEDIF(A1,B1,"md")>14,1,0.5)
Change the bolded part as needed

 

[xtinct2]

thanks all
(sorry for my math -- 2.5 is correct)
)

 

[FDibbins]

Happy to help