To get the current date in Excel, you generally have to utilize the **TODAY()** formula. This article will show you the various ways of how to apply the **TODAY()** formula to get the required output.

**Table of Contents**hide

## Download Workbook

## Current Date and Time Formula in Excel

Here you will learn how to implement the TODAY() formula in Excel to find certain dates.

### 1. To Get the Current Date

**Syntax:** `=TODAY()`

**Step 1:** In an empty cell, first put an **equal (=)** sign.

**Step 2:** Then write **TODAY()**.

**Step 3:** Hit **Enter**.

It will show you the current date.

### 2. To Get the Current Date and Time

**Syntax:** `=NOW()`

**Step 1:** In an empty cell, first put an **equal (=)** sign.

**Step 2:** Then write **NOW()**.

**Step 3:** Hit **Enter**.

It will show you the current date and time.

### 3. To Get the Current Day of the Month

**Syntax:** `=DAY(TODAY())`

**Step 1:** In an empty cell, first put an **equal (=)** sign.

**Step 2:** Then write **DAY(TODAY())**.

**Step 3:** Hit **Enter**.

It will show you the current day of the current month.

### 4. To Get the Current Month of the Year

**Syntax:** `=MONTH(TODAY())`

**Step 1:** In an empty cell, first put an **equal (=)** sign.

**Step 2:** Then write **MONTH(TODAY())**.

**Step 3:** Hit **Enter**.

It will show you the serial number of the current month of the current year.

### 5. To Get the Number of Days Between the Current Date and a Specific Date

**Syntax:** `=TODAY()-”date”`

**Step 1:** In an empty cell, first put an **equal (=)** sign.

**Step 2:** Then write **TODAY()**, put a **subtraction (-)** sign and then write the date that you want to subtract from the current date (e.g. *=TODAY()-”09/4/2021”*).

Step 3: Hit **Enter**.

It will show you the number of days between the current date and a specified date by you.

- If you don’t want to write the whole date every time, then:

**Step 1:** Store the date in another empty cell.

**Step 2: **Then just subtract the cell reference from **TODAY()**.

To understand more see the given picture below, where we store the date *“09/04/2021”* in the *C4* cell and later subtract the *C4* from **TODAY()**.

It will also show you the number of days between the current date and a specified date by you.

### 6. To get a Certain Month in the Future from Current Date

**Syntax:** `=EDATE(TODAY(),”number_of_months”)`

**Step 1:** In an empty cell, first put an **equal (=)** sign.

**Step 2:** Then write **EDATE(TODAY(),”****number_of_months****”)**.

Here, *number_of_months* represents the number of the months that you want to include with the current month.

To understand more see the picture above, where we wanted to see the date of two months ahead of the current month, so after writing the formula **TODAY()**, we wrote the number **2**.

**Step 3:** Hit **Enter**.

It will also show you the upcoming date from the current date.

### 7. To get a Certain Month in the Past from Current Date

**Syntax:** `=EDATE(TODAY(),-”number_of_months”)`

**Step 1:** In an empty cell, first put an **equal (=)** sign.

**Step 2: **Then write **EDATE(TODAY()**, **subtraction sign (-)** and **”****number_of_months*** ”)*.

Here, *number_of_months* represents the number of the months that you want to exclude from the current month.

To understand more see the picture above, where we wanted to see the date of two months back from the current month, so after **TODAY()**, we put a **subtraction sign (-)** and wrote the number** 2** to subtract two months from the current date.

It will also show you the previous date from the current date.

### 8. To Get a Certain Date in the Future from Current Date

**Syntax:** `=TODAY()+”number_of_days”`

**Step 1:** In an empty cell, first put an **equal (=)** sign.

**Step 2:** Then write **TODAY()**, put an **addition (+)** sign and after that write the number of days that you want to add to today’s date.

To understand more see the picture above, where we wanted to know the date of 5 days ahead of the current date, so we add (+)** 5** with the **TODAY()** formula.

**Step 3:** Hit **Enter**.

It will also show you the upcoming date from the current date.

### 9. To Get a Certain Date in the Past from Current Date

**Syntax:** `=TODAY()-”number_of_days”`

**Step 1:** In an empty cell, first put an **equal (=)** sign.

**Step 2:** Then write **TODAY()**, put a **subtraction (-)** sign and after that write the number of the days that you want to remove from today’s date.

To understand more see the picture above, where we wanted to know the date of 5 days back from the current date, so we subtract (-) **5** from the **TODAY()** formula.

**Step 3:** Hit **Enter**.

It will also show you the previous date from the current date.

### 10. To Get the First Day of Current Month

**Syntax:** `=EOMONTH(TODAY(),-1)+1`

**Step 1:** In an empty cell, first put an **equal (=)** sign.

**Step 2:** Then write **EOMONTH(TODAY(),-1)+1**

**Step 3:** Hit **Enter**.

It will also show you the first day of the current month.

### 11. To Get the Number of Remaining Days from Current Date

**Syntax: =”date”-TODAY()**

**Step 1:** In an empty cell, first put an **equal (=)** sign.

**Step 2:** Then write the date from which you want to count the number of days to the current date, put a **subtraction (-)** sign, and then write **TODAY()** (e.g. *=”31/12/2021”-TODAY()*).

**Step 3:** Hit **Enter**.

It will show you the number of remaining days between a specified date and the current date.

- If you don’t want to write the whole date every time, then:

**Step 1:** Store the date in another empty cell.

**Step 2:** Then just subtract **TODAY()** from the cell reference.

To understand more see the given picture below, where we store the date *“31/12/2021”* in the *C4* cell and later subtract **TODAY()** from the cell *C4*.

It will show you the number of remaining days between a specified date and the current date.

## Things to Remember

Don’t forget to **update the cell format according to your data format**, meaning when you are working on getting the date as output, update the format of the cell in the category of Date. Similarly, when you want the number of days as output, update the cell format as the Number category.

There are pictures given below on how to change cell formation.

**First**, right-click on the cell and from the pop-up list select **Format Cells**.

**Next**, from the second pop-up window, choose the category of your cell from the **Category** list. Click **Ok**.

## Conclusion

This article discussed different ways of using the current date formula in Excel to extract the current dates and the number of days counts between dates.