Return a value from a different cell for two times a year

[rubenovik]

Hi, I have been looking and trying for a formula that will return a given value from a different cell for the last given date of the month of June and the last given date of December. So far I haven't been able to create a correct one. Hopefully it is possible.
Dates are in column A and spread with a period of 14 days apart. The formula would return the provided value in cell F10 to column C when the last date of the period in June and December is found. Dates run infinitely with the very first date in cell A2 changing once in a while. This is the URL to the location of a picture of the first page. Thanks in advance.

https://www.dropbox.com/s/uzpq200o3yjnbld/test.PNG?dl=0

 

[steve the fish]

Are we talking of every June and December or just in 2019? This would work for 2019 if you have MAXIFS function. Depends on your version of excel.

=IF(OR(A2=MAXIFS(A:A,A:A,">="&DATE(2019,6,1),A:A,"<"&DATE(2019,7,1)),A2=MAXIFS(A:A,A:A,">="&DATE(2019,12,1),A:A,"<"&DATE(2020,1,1))),$F$1,"")

 

[rubenovik]

Thanks for the reply. The dates on my spreadsheet run from 2019 to 2050. I tried this formula but realized the Excel version is from 2010 which doesn't include the MAXIFS function. I wonder if I have to update to a new version now.