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
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