Google News
logo
Microsoft Excel - Quiz(MCQ)
Which function is used to create a date with year, month, and day?
A)
DATE()
B)
CURDATE()
C)
DATEDIF()
D)
DATEVALUE()

Correct Answer : Option (A) :   DATE()


Explanation :

The DATE() function is used to create a date with year, month, and day.
 
Syntax : =DATE (year, month, day)

Example : =DATE(2022,2,20) // returns Feb 20, 2022

Advertisement