DATEDIF Month Count with Rounding Up?

[slam]

Hi all,

I have a simple formula to count the months between two dates:

=DATEDIF(H2,J2,"M")

I'm struggling to tweak it to count any months, regardless of how many days within that month. ROUNDUP is perhaps not what I need.

So if my first date was 28 Feb 2023, and my second date was 01 Mar 2023, I would want the count to be 2 Months. With the formula above, it's giving me a 0 of course.

Any help would be greatly appreciated.

 

[Fluff]

How about

=month(J2)-month(H2)+1

 

[slam]

Perfect, thank you so much for your speedy reply!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[slam]

How about

=month(J2)-month(H2)+1

Hi Fluff,

I apologize for not noticing this earlier, but I just noticed that this formula won't work if the dates span multiple years. For instance, if I have a Start Date of 01 Jun 2022, and an End Date of 31 Dec 2024, which I think is 31 months, it will only display 7. It's ignoring the year, and only counting the months June to December.

Could you please help me accommodate this?

Thank you so much

 

[Fluff]

How about

=MONTH(J2)-MONTH(H2)+1+(YEAR(J2)-YEAR(H2))*12

 

[Dave Patton]

T202303a.xlsm
	H	I	J	K
1	Number of months
2	28-02-23		01-03-23	2
3	01-06-22		31-12-24	32
4
4e

Cell Formulas
Range	Formula
K2:K3	K2	=DATEDIF(H2-DAY(H2),J2,"m")+1

 

[Dave Patton]

Ignore previous post. The expected answer was 31.

=DATEDIF(H2-DAY(H2),J2-DAY(J2)+1,"m")+1

 

[Zwafel]

Since DATEDIF already gives the desired answer if the DAY() of the two months are equal (no rounding up or down necessary), you'd only want to add an extra month when the days differ. I like to use the following to round up with DATEDIF.

=DATEDIF(A1,B1,"m")+(DAY(A1)<>DAY(B1))