Asked by PERLA MENDIOLA on Jun 15, 2024

verifed

Verified

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)

DATE Function

A formula in spreadsheet software that generates a date value from individual year, month, and day components.

  • Gain expertise in the use of Excel for managing date and time.
verifed

Verified Answer

LM
Lesley ManningJun 19, 2024
Final Answer :
A
Explanation :
The correct formula to insert the date January 12, 1998 into a cell is =DATE(1998,1,12). This is because the DATE function takes three arguments, in the order of year, month, and day, separated by commas. Therefore, we input 1998 as the year, 1 as the month (which corresponds to January), and 12 as the day.