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. Change the formatting to a number if the results from DATE() is formatted as a date.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.