Result: 42551 'Which can be formatted as '' Result: 42613 'Which can be formatted as '' In column E, we have formatted the result from the DATE function as mm/d/yyyy.īased on the Excel spreadsheet above, the following DATE examples would return: =DATE(A3,B3,C3) We also wanted to show you the result as a formatted date which is how a user would format the results. Let's look at some Excel DATE function examples and explore how to use the DATE function as a worksheet function in Microsoft Excel:īecause the DATE function returns a serial date, we wanted to show you the result from the DATE function as an unformatted serial date which you can see this in column D.
