1. DATE() - In the OrderHeaders worksheet, in cell AB2 use DATE() and find out how many days there have been since 1/1/1900 and 12/4/2020 (you can enter the assignment due date inside DATE(). Change the formatting to a number if the results from DATE() is formatted as a date. Also change the formatting of the value in G2 to a number. Notice that the results in Question 12 do not change.

In column W use DATE() inside an if statement to return Yes if the OrderDate is in the first quarter of 2018, and otherwise No.

In column X, use DATE() inside an if statement to return Yes if the order date is after (strictly greater than) 10/15/2018, and otherwise No.

In column Y, use AND() and DATE() inside an if statement to return Yes if the order date is before (strictly less than) 11/18/2018 and has not yet been shipped, and otherwise No.

Note that the function DATEVALUE() works the same way as DATE(), but converts a date string, e.g., 11/2/2019, rather than integers separated by commas, e.g., 2019,11,2, to the number of days since 1/1/1900.