*****HOW TO SET UP AN EQUATION FOR THE FOLLOWING TASKS ON EXCEL*****

1. QUARTER in Column AB, defined as:
   1. Spring if Order Date is between March 1 and May 31
   2. Summer if Order Date is between June 1 and August 31
   3. Fall if Order Date is between September 1 and November 30, and
   4. Winter if Order Date is between December 1 and February 29.
2. FISCAL_YEAR of the Order Date in Column AC, corresponding to the Fiscal Year dates of Sept 1 to August 31, written as FYXXXX where XXXX is the date. For example, the current fiscal year which began on 1 September 2021 will end on 31 August 2022, and would be written as "FY2022". An Order Date of July 1, 2021 would be FY2021. An Order Date of Dec 12, 2021 would be FY2022.
3. RECALL in Column AD, defined as: if the product number ends in 55, and the order date is prior to the first of January 2008, then the product has been recalled. For products recalled, the cell value in AD should be True, otherwise the value should be False.

I tried to attach the file but I couldnt tho. I just need the equation that gives me the same required outputs, please. Thanks a lot.

a : KEY LEET 1/16/12 a : KEY LEET 1/16/12