Calculate months withing 1st and 2nd half of the year depeding on changable date

[JasXel]

Hi all,

I am trying to calculate the months within first and second half per year depending on selected dates. So the user should be able to change the dates as desired, and per year I need to know how many months fall in 1st half and how many in the 2nd half of each selected year. The maximum duration the user can select is 6 years. If the user selects less it should of course return 0.

Attached is my example file.

I have the feeling I am thinking too complicated here.

Thanks a lot for your help.

[Bo_Ry]

Please try at F2:K3

=IFERROR(DATEDIF(MAX(DATE(F$1,ROWS(F$2:F2)*6-5,1),EOMONTH($A$2,-1)),MIN(DATE(F$1,ROWS(F$2:F2)*6+1,1),EOMONTH($B$2,0)+1),"M"),0)

[JasXel]

Please try at F2:K3

=IFERROR(DATEDIF(MAX(DATE(F$1,ROWS(F$2:F2)*6-5,1),EOMONTH($A$2,-1)),MIN(DATE(F$1,ROWS(F$2:F2)*6+1,1),EOMONTH($B$2,0)+1),"M"),0)

Excellent! Thanks a lot!