Excel Current Date Formula (with 11 Easy Examples)

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.

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()

excel current date formula 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()

To Get the Current Date and Time

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())

To Get the Current Day of the Month

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())

To Get the Current Month of the Year

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”

To Get the Number of Days Between the Current Date and a Specific 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().

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

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”)

To get a Certain Month in the Future from Current Date

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”)

To get a Certain Month in the Past from Current Date

 

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”

To Get a Certain Date in the Future from Current Date

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”

To Get a Certain Date in the Past from Current Date

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

To Get the First Day of Current Month

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()

To Get the Number of Remaining Days from Current Date

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.

To Get the Number of Remaining Days from Current Date

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.

formatting cells based on category

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

formatting cells based on category

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.

Sanjida Ahmed

Sanjida Ahmed

Hello World! This is Sanjida, an Engineer who is passionate about researching real-world problems and inventing solutions that haven’t been discovered yet. Here, I try to deliver the results with explanations of Excel-related problems, where most of my interpretations will be provided to you in the form of Visual Basic for Applications (VBA) programming language. Being a programmer and a constant solution seeker, made me interested in assisting the world with top-notch innovations and evaluations of data analysis.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo