Greetings,

I would like to get some ideas on how to return a date in a new cell based on the following criteria:

Cell A1: The Date I am referencing (i.e. 07/01/2019)
Cell A2:
If the date is between Jan 01 and March 31, return 03/31/YYYY where YYYY is the year in cell A1
If the date is between April 01 and December 31, return 12/31/YYYY where YYYY is the year in cell A1


So if the date is 07/01/2019 in cell A1, then A2 would reflect 12/31/2019 because the range is between April 01 and December 31.

Thanks in advance for your help with this.