Which function is used to create a Date with year, month, and day in Excel?
DATE()
DATEDIF()
DATEVALUE()
CURDATE()
Correct answer is A
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