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?

1. DATE()
2. DATEDIF()
3. DATEVALUE()
4. 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