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

Looking for the right answers by using the DATE command with IF statement only, by using the Order Date.
 

D E ID CustomerCompanyName EmployeelD OrderDate R 5 1/15/2017 6 1/16/2017 4 1/19/2017 Wilman Kala Tradio Hipermercados Hanari Carnes Victuailles en stock 3 1/19/2017 Suprmes dlices 4 1/20/2017 Hanari Carnes 3 1/21/2017 Chop-suey Chinese Richter Supermarkt 5 1/22/2017 9 1/23/2017 3 1/26/2017 Wellington Importadora HILARIN-Abastos 4 1/27/2017 Ernst Handel 1 1/28/2017 Centro comercial Moctezu 4 1/29/2017 Old World Delicatessen 4 1/30/2017 Que Delcia 4 1/30/2017 Rattlesnake Canyon Groce 8 2/2/2017 2/3/2017 2/4/2017 Ernst Handel Folk och f HB 6. Blondel pre et fils 2/5/2017 Wartian Herkku 3. 2/6/2017 Frankenversand 4 2/9/2017 8 2/10/2017 5 2/11/2017 Employee GROSELLA-Restaurante White Clover Markets ucts Categories Shippers Suppliers