Jose inserts the formula =DATE(2021, 2, 15) in cell A15.When he presses ENTER, 2/15/2021 will appear in the cell.

Name: Jose inserts the formula =DATE(2021, 2, 15) in cell A15.When he presses ENTER, 2/15/2021 will appear in the cell.
Brand: Quizplus
Rating: 4.9 (39 reviews)

Question

Quizplus · Accepted Answer

The DATE function in Excel returns a date value based on year, month, and day inputs. In this case, the formula =DATE(2021, 2, 15) will return the date 2/15/2021 when entered into cell A15.

Jose Inserts the Formula =DATE(2021, 2, 15) in Cell A15