How to create date in Microsoft Excel | Use of DATE function (formula) in Excel

DATE

Use of DATE Function / Formula in Excel

This function displays a date based on uts three arguments such as year, month, day.

Syntax/Formula of DATE Function in Excel

The syntax of DATE function in Microsft Excel is below.

=DATE(year, month, day)

Example of DATE Function in Excel

Step 1: Type date 25 in cell B5, month 12 in cell B6, and year 1955 in cell B7 as shown in below image.

Step 2: Type formula =DATE(B7,B6,B5) in cell B9 and press enter.

DATE