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.


Download Practice Workbook

You can download the practice workbook from here:


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.

Dataset for using Excel Formula to Calculate Number of Days Between Today and Another Date


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.

Simple Subtraction Formula to Calculate Number of Days Between Today and Another Date in Excel

  • 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.

Result for using Subtraction as Excel Formula to Calculate Number of Days Between Today and Another Date

Read More: How to Subtract Dates in Excel to Get Years (7 Simple Methods)


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.

Using TODAY Function to Calculate Number of Days Between Today and Another Date in Excel

  • 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.

Read More: How to Calculate Days Outstanding in Excel (With Easy Steps)


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.

Applying DAYS Function to Calculate Number of Days Between Today and Another Date in Excel

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

Finally, you will get all the number of days.

Result of using DAYS function as Excel Formula to Calculate Number of Days Between Today and Another Date

Read More: How to Count Days from Date to Today Automatically Using Excel Formula


Similar Readings


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.

Utilizing DATE Function in Excel to Calculate Number of Days in Excel

  • 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.

Read More: Calculate Number of Days between Two Dates with VBA in Excel


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.

Use of DATEDIF Function to Calculate Number of Days Between Today and Another Date

  • 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.

Read More: How to Calculate Number of Days Between Two Dates in Excel


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.

Employing NETWORKDAYS Function in Excel to Calculate Number of Days Between Today and Another Date

  • 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.

Read More: How to Calculate Working Days Excluding Sundays in Excel


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.

Use of Combined Functions to Calculate Number of Days to Calculate Number of Days Between Today and Another Date

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.

Read More: Excel Formula to Count Days from Date (5 Easy Methods)


Practice Section

Now, you can practice the explained method by yourself.

Practice Section to Calculate Number of Days Between Today and Another Date


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.


Further Readings

Md. Abdul Kader

Md. Abdul Kader

Hi! I am Abdul Kader and presently working as ‘Excel & VBA Content Developer’ at Exceldemy. I publish my articles related to Microsoft Excel here. In 2019, I completed my graduation in Urban and Regional Planning from Chittagong University of Engineering and Technology. Having extreme eagerness to learn, I want to develop my skills and capabilities higher.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo