What is the correct formula to insert the date January 12,1998 into a cell?
A) =DATE(1998,1,12)
B) =DATE(1998,12,1)
C) =DATE(12-1-1998)
D) =DATE(1/12/1998)

Question

Quizplus · Accepted Answer

The correct formula to insert the date January 12, 1998 into a cell is =DATE(1998,1,12). The format for the DATE function is =DATE(year, month, day) where year is represented by four digits, month is represented by a number from 1 to 12, and day is represented by a number from 1 to 31.

What Is the Correct Formula to Insert the Date January