| Be My Friend

Date Formula in Excel

Date Function | Syntax | Example | Using Negative Values | How to Subtract Date | Current Date

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

You May Also Like the Following Excel Tutorials:


Subscribe for more videos on our Youtube channel. if you like our tutorial please Like and Subscribe to our Facebook and Youtube.

Download the Sample Date Formula in Excel file for free.

To Get FREE Excel Shortcut Keys



Why basictutorials.in?

To Learn:

Tutorials in a simple Way.

Excel with downloadable samples.

HTML with sample website code.

PowerPoint presentations.

MS Word for offical use.

Useful Tutorials