datedif...but month count

[Pizzio]

I feel like I'm making this way more difficult than I need to.

01/18/22 - 02/18/22 - looking for a formula that will count the months to give the return of 2 for Jan/Feb

 

[njimack]

=DATEDIF(A1,A2,"m")+1
(based on your very small sample. if this isn't what you wanted, please post more examples)

 

[Dave Patton]

T202203a.xlsm
	A	B	C
1
2	18-Jan-22	18-Feb-22	2
3	15-Mar-22	5-May-22	3
4
2d

Cell Formulas
Range	Formula
C2:C3	C2	=MONTH(B2)-MONTH(A2)+1

 

[njimack]

T202203a.xlsm
	A	B	C
1
2	18-Jan-22	18-Feb-22	2
3	15-Mar-22	5-May-22	3
4
2d

Cell Formulas
Range	Formula
C2:C3	C2	=MONTH(B2)-MONTH(A2)+1

That won't work for Dec / Jan

 

[Pizzio]

That won't work for Dec / Jan

You are correct...it didn't work in the calendar year transition. I used the datedif formula on 01/3022 - 02/20/22 and it still comes back as 1 month. This is with including the +1 in the calculation. Any thoughts?

 

[Dave Patton]

try

T202203a.xlsm
	A	B	C	D
1
2	18-Jan-22	18-Feb-22		2
3	15-Mar-22	5-May-22		3
4	15-Dec-22	5-Jan-23		2
5	5-Mar-21	31-May-21		3
6	30-Jan-22	20-Feb-22		2
7
8
2d

Cell Formulas
Range	Formula
D2:D6	D2	=DATEDIF(EOMONTH(A2,-1)+1,EOMONTH(B2,0)+1,"m")

 

[Dave Patton]

You can also try =(YEAR(B2)-YEAR(A2))*12+MONTH(B2)-MONTH(A2)+1

T202203a.xlsm
	A	B	C	D	E
1
2	18-Jan-22	18-Feb-22	2	2	2
3	15-Mar-22	5-May-22	3	3	3
4	15-Dec-22	5-Jan-23	2	2	2
5	5-Mar-21	31-May-21	3	3	3
6	30-Jan-22	20-Feb-22	2	2	2
7
2d

Cell Formulas
Range	Formula
C2:C6	C2	=DATEDIF(EOMONTH(A2,-1)+1,EOMONTH(B2,0)+1,"m")
D2:D6	D2	=DATEDIF(A2-DAY(A2)+1,EDATE(B2-DAY(B2)+1,1),"m")
E2:E6	E2	=(YEAR(B2)-YEAR(A2))*12+MONTH(B2)-MONTH(A2)+1