The DATE function is used to form the date with the given values like day, month and year. Note: The year has to be selected first while using this function. The year should be followed by month and then the day.
Formula:
=DATE(year, month, day)
Video Tutorial:
Let us learn to write the date with the given values like day, month and year, using DATE function with the help of the below video