Date Function in Excel

The Date function in Excel creates a valid date from the individual year, month, and day components.

In other words, you can use the Excel DATE function to get the date value using the year, month and, day values as the input arguments.

Date Formula Syntax

=DATE(year, month, day)

Arguments Explained:

  • year - Number for year.
  • month - Number for month.
  • day - Number for day.

Date Function Examples

In the below example we have a date, month, and year in a separate column. to get the exact date using these values I have added a date formula i.e=DATE(C3, B3, A3) in cell D3.

That means, to get date value we are using the Excel date formula with day, month, and year arguments.

Date Formula in Excel

What Happens if you Use Negative Values?

You can also use negative values for day and month in a date function.

In the below example I have added -02 in a month, That's why it goes back by 2 months and returns its date value.

In the same way, I have added -07 in a day, so it goes back by 7 days and returns its date value.

Date Formula Negative Values in Excel

How to Subtract Date In Excel?

It is easy to subtracting dates in Excel.

In the below example, To find the number of days between the start date and end date, we have used the formula =G3-F3.

Result is,

Subtract Date in Excel

Formula for Current Date in Excel

To get the current date in Excel use the TODAY function. it will automatically update your Computer / Laptop date.

Use the shortcut key CTRL +; to add the TODAY function.

Formula for Current Date in Excel


Get Your FREE Excel Shortcut Keys e-BOOK