Date formula for month count within a specific range

[Gevans0666]

I have a contract start date and end date... dates are all ranges from 2018/19 and earlier to 2021 and longer

I have 7 columns for:

1 Start Date (provided)
2 End Date (provided)
3 total month count =IF(G2="",0,DATEDIF(F2,G2,"m"))+1
4 Previous
5 2019
6 2020
7 Balance

I need 4 formulas that filter the correct month count under each column. Having no luck at all!

 

[Dave Patton]

Excel 2010
	F	G	H	I	J	K	L
1	Start	End	Months	Previous	2019	2020	2021
2	31-May-17	31-Dec-20	43	19	12	12	0
3	1-Jan-18	1-Jan-21	36	12	12	12	0
4	1-Jan-19	31-Dec-21	36	0	12	12	12
5c

Cell Formulas
Range	Formula
H2	=IF(G2="",0,DATEDIF(F2-1,G2,"m"))
I2	=DATEDIF(F2,MIN($J$1,G2),"m")
J2	=MIN(12,$H2-SUM($I2:I2))
K2	=MIN(12,$H2-SUM($I2:J2))
L2	=MIN(12,$H2-SUM($I2:K2))

2019 or 2019-2021 are dates like 1-1-2019 formatted as yyy