Question

Jose inserts the formula '=DATE('2000, 2, 2)' in cell AI5. Upon pressing ENTER, what will appear in AI5?

1) 2/2/2000
2) 2-2-2000
3) 2nd February 2000
4) 2000-02-02

Answer 1

The formula '=DATE('2000, 2, 2)' in cell AI5 will display the date 2/2/2000.

Step-by-step explanation:

When Jose inserts the formula '=DATE('2000, 2, 2)' in cell AI5 and presses ENTER, the date 2/2/2000 will appear in AI5.