Home »
MCQs »
Microsoft Excel MCQs
Which function is used to create a date with year, month, and day?
24. Which function is used to create a date with year, month, and day?
- DATE()
- DATEDIF()
- DATEVALUE()
- CURDATE()
Answer: 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,8,26) // returns Aug 26, 2022