DATEDIF for count of Months occurring in specific year between 2 dates

[slam]

Help on this quick one would be incredibly appreciated! <3

I have a start date in column F and an end date in column G.

I need to know how many months between those two dates, occur in the year 2023, so the result should be between 0 & 12.

Thank you!

 

[Jeffrey Mahoney]

This is kind of simple

Book4
	F	G	H
1	Beg Year	End Year	Days Per Month
2	1/1/2023	12/31/2023	30
3
4
5	2/1/2023	5/1/2023	3
6	2/1/2023	9/1/2023	7
7	2/1/2023	2/1/2024	11
8	5/1/2022	5/1/2023	4
Sheet1

Cell Formulas
Range	Formula
H5:H8	H5	=(MIN(G5,$G$2)-MAX(F5,$F$2))/$H$2