Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

# Excel Formula to Calculate Number of Days Between Today and Another Date

Do you want to calculate the number of days between Today and another date using the Excel formula?  In the past, people used to calculate it manually. But at present with the advancement of modern tools, it is quite easy to calculate it using these modern tools.

Today we will explain how to use an Excel formula to calculate the number of days between Today and another date using the Microsoft 365 version.

## 7 Formula to Calculate Number of Days Between Today and Another Date in Excel

In this article, we’re going to demonstrate seven quick and simple methods to calculate the number of days between Today and another date using an Excel formula. For your better understanding, I am going to use the following dataset. Which contains two columns. Those are Order ID, and Order Date. The dataset is given below. ### 1. Simple Subtraction Formula to Calculate Number of Days Between Today and Another Date

We can easily find the number of days using the subtraction method. The two options may be utilized. The earlier days are determined by subtracting the order date (any other date) from today.

Steps:

• Firstly, select the blank cell C20.
• Secondly, enter the formula.
`=TODAY()`

Here, the TODAY function will return the current date. • Subsequently, press ENTER.

As a result, you will get the current date. • Similarly, select another blank cell D5.
• Then, enter the following formula.
`=\$C\$20-C5 `

Where \$C\$20 and C5 are the current date and order date respectively.

• After that, press ENTER. • Here, use the Fill Handle tool for filling up the blank cells. Just drag the cursor at the lower right corner of D5 cells and you will see a Plus (+) sign. Now, move the cursor down up to D9 cell. Lastly, you will get the output like the following. The later days are determined by subtracting the date of the current day (today) from the order date (any other date).

Steps:

• Firstly, select the blank cell D14.
• Secondly, enter the formula.
`=C14-\$C\$20`

Where C14 and \$C\$20 are the probable delivery date (future date) and present date respectively.

• Thirdly, press ENTER. • At this time, use the Fill Handle tool for filling up the blank cells and you will get the output like the following. ### 2. Using TODAY Function in Excel

The syntax of the function is

=TODAY()-Cell(another date)

Basically, the TODAY function restores the serial number, a date-time code, provided by Excel. And you can calculate the number of days by subtracting any days from today.

Steps:

• Firstly, pick the blank cell D5.
• Secondly, type the following formula.
`=TODAY()-C5`

Where C5 is the order date. Remember TODAY is a separate function for finding the date of the present day.

• Thirdly, press ENTER. • After that, use the Fill Handle icon for filling up D6 to D9 cells with the same formula.

Lastly, you will get all the days’ numbers. Note: Here, the TODAY function will give exactly the present date. So, you may find different date in the worksheet as the TODAY function will change as every day.

### 3. Applying DAYS Function to Calculate Number of Days Between Today and Another Date

Here, you can use the DAYS function as an Excel formula to calculate the number of days between Today and another date. Additionally, the syntax of the function is

= DAYS(end_date, start_date)

Now, for applying the syntax just follow the steps given below.

Steps:

• Firstly, click the blank cell D5.
• Secondly, type the formula in the D5 cell.
`=DAYS(\$C\$11,C5)`

Where \$C\$11 is the end date and C5 is the start date. Here, we’re using the Absolute Reference for cell C11 to keep fixed the present date for all other order dates.

• Thirdly, press ENTER. • Subsequently, use the Fill Handle tool like the previous method.

Finally, you will get all the number of days. ### 4. Utilizing DATE Function in Excel to Calculate Number of Days

Again, you can use the DATE function as an Excel formula to calculate the number of days between Today and another date. Furthermore, the syntax of the function is as below.

=DATE(year, month, day)-DATE(year, month, day)

Steps:

• Firstly, select the blank cell D5.
• Secondly, input the formula given below.
`=DATE(2022,10,17)-DATE(2020,6,1)`

Here, the DATE function will return the date number as Excel.  Basically, in this formula, we’re subtracting two dates. But, you have to insert the year, month, and day manually.

• Subsequently, press ENTER. • Similarly, input the formula in the D6 cell.
`=DATE(2022,10,17)-DATE(2020,8,27)`
• Then, press ENTER. • In the same way, you have to insert both the present and order dates and you will get all the number of days between today and another date. ### 5. Use of DATEDIF Function to Calculate Number of Days

Let’s consider a dataset like the following where Order ID, Order date, and the date of the current day are given. Now, we have to find the number of days between the order date and today. Regarding this, we can utilize the DATEDIF function. The main formula of the function is

=DATEDIF(start_date,end_date, “d”)

Here, the d provides the complete number of days from the two dates.

Steps:

• Now, select the blank cell D5 and input the formula like
`=DATEDIF(C5,\$C\$11,"d")`

Where C5 and \$C\$11 are the start date and end date respectively. Also, d refers to Days (full days).

• Then, press ENTER. • Right now, you might use the Fill Handle tool for filling up the blank cells.

As a result, you will get the output like the following. Note: DATEDIF is a hidden function in Excel. Actually, you will not find it anywhere in Excel Toolbar. So, you have to write the full name in the cell or Formula Bar to get it.

### 6. Employing NETWORKDAYS Function in Excel

The NETWORKDAYS function calculates the number of days between two days. It has a special character, and it can exclude any specified holidays. Syntax of the function is:

=NETWORKDAYS(start_date, end_date, holidays)

Now, if you want to apply the syntax for your dataset. Just follow the below steps.

Steps:

•  Firstly, you have to make a list of all holidays of a year. Here, we have listed in column E.
• Secondly, select the blank cell C11.
• Thirdly, type the formula.
`=TODAY()`

Remember TODAY is a separate function for finding the date of the present day.

• Fourthly, press ENTER. • Now, select another blank cell D5.
• Then, type the following formula.
`=NETWORKDAYS(C5,\$C\$11,\$E\$5:\$E\$9)`

Where C5 is the order date, \$C\$11 means today and \$E\$5:\$E\$9 are holidays.

• After that, press ENTER. • Now, use the Fill Handle tool for filling up D6 to D9 cells.

Lastly, you will get all the number of workdays. ### 7. Use of Combined Functions to Calculate Number of Days

You can employ a combination of some functions like the ABS function, IF function, ISBLANK function, and TODAY function as an Excel formula to count the number of days between today and another date. The steps are given below.

• Firstly, you have to select a new cell D5 where you want to keep the result.
• Secondly, you should use the formula given below in the D5 cell.
`=ABS(IF(ISBLANK(C5),"",TODAY()-C5))`
• Finally, press ENTER to get the result. Formula Breakdown

• Here, the logical test of the IF function is “ISBLANK(C5)”. Which will check whether the cell value of C5 is blank or having value.
• Then, if the C5 has no cell value then the IF function will return a blank space.
• Otherwise, it will do this operation “TODAY()-C5”. Where the TODAY function will give the current date and the whole scenario will return the number of days between today and the date from the C5 cell.
• Lastly, the ABS function will convert the returned number into a positive one.

• Subsequently, use the Fill Handle tool like the previous method.

Finally, you will get all the number of days. ## Practice Section

Now, you can practice the explained method by yourself. ## Conclusion

Applying the seven quick and simple methods, you can easily find out an Excel formula to calculate the number of days between today and another date. Thanks for reading my article. Please share your thoughts below.  