Asked by PERLA MENDIOLA on Jun 15, 2024
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.
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.
Learning Objectives
- Gain expertise in the use of Excel for managing date and time.
Related questions
Rohan Can Display the Current Date in a Cell Using ...
Jose Inserts the Formula =DATE(2021, 2, 15) in Cell A15 ...
The Results of Formula =TIMEVALUE(10:30 AM) Is the Value 10:30
Sheila Wants to Extract the Hour from the Time, 12:00:56 ...
A Student Types the Formula '= YEAR( TODAY())-2005' to Calculate ...