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.
 

Transcribed Image Text:

D E ID CustomerCompanyName EmployeelD OrderDate R 5 1/15/2017 6 1/16/2017 4 1/19/2017 Wilman Kala Tradição Hipermercados Hanari Carnes Victuailles en stock 3 1/19/2017 Suprêmes délices 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 HILARIÓN-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 Delícia 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 père 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 D E ID CustomerCompanyName EmployeelD OrderDate R 5 1/15/2017 6 1/16/2017 4 1/19/2017 Wilman Kala Tradição Hipermercados Hanari Carnes Victuailles en stock 3 1/19/2017 Suprêmes délices 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 HILARIÓN-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 Delícia 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 père 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

Answer rating: 100% (QA)

Make sure that the Cell References are correct with data on your side All possible use cases are als... View the full answer