DATE Function Syntax & Arguments
The Excel DATE function combines three values to create a date.
In this example, were making 2020 theyearargument, butmonthanddayis being pulled from other cells.
Subtract Months Using Negative Month Argument
Here, were using a negative number in themonthspace.
This DATE formula produces10/15/2019.
Large Day & Month Arguments
This example combines a few of the rules mentioned above.
This DATE formula produces 8/19/2021.
In this example, were wanting to see the date thats 10 years past an existing date.
In this example, E10 is 8/4/2018, so the result is216.
The calculated date is4/17/2020.
See our articles on using Excel’sLEFT,RIGHT, andMIDfunctions for more information.
