Excel Formula to Calculate Number of Days Between Today & Another Date (6 Quick Ways)

Do you want to calculate the number of days between today and the other date? You can easily compute the number of days using Excel.

In this article, I’m going to demonstrate six quick and simple Excel formulas for calculating the number of days.

Download Practice Workbook

Excel Formula to Calculate Number of Days Between Today and Another Date (6 Quick Ways)

1. Simple Subtraction Formula

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:

  • Select the blank cell D2
  • Enter the formula =C3-B3 where C3 and B3 are the current date and order date respectively
  • Press Enter
  • Use the Fill Handle Tool for filling up the blank cells and you will get the output like the following

Simple Subtraction Formula

The later days are determined by subtracting the date of the current day (today) from the order date (any other date).

Steps:

  • Select the blank cell D11
  • Enter the formula =C11-B11 where C11 and B11 are the probable delivery date(future date) and order date respectively
  • Press Enter
  • Use the Fill Handle Tool for filling up the blank cells and you will get the output like the following

Simple Subtraction Formula

2. Using TODAY Function

The syntax of the function is

=TODAY()-Cell(another date)

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:

  • Pick the blank cell C3
  • Type =TODAY()-B3 where B3 is the order date
  • Remember TODAY is a separate function for finding the date of present day
  • Press Enter
  • Use Fill Handle Formula for filling up C4 to C7 cells.

Using TODAY Function

3. Using DAYS Function

The syntax of the function is 

DAYS(end_date, start_date)
. For applying the syntax just follow the steps-

Steps:

  • Click the blank cell D3
  • Type the formula =DAYS(C3, B3) where C3 is the end date and B3 is the start date
  • Press Enter and use the Fill Handle Tool like the previous method

Using DAYS Function

4. Utilizing DATE Function

The syntax of the function is

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

Steps:

  • Select the blank cell D3
  • Input the formula =DATE(2021,6,22)-DATE(2020,6,1)
  • Press Enter

Using DATE Function

5. 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, holidays)

here the d provides the complete number of days from the two dates.

Step 1: 

  • Select the blank cell E3 and input the formula like =DATEDIF(C3, D3,"d") where C3 and D3 are start date and end date respectively. Also, d refers to Days (full days).

DATEDIF function

Step 2:

  • Right now you might use the Fill Handle Tool for filling up the blank cells. Just drag the cursor at the lower right corner of E3 cells and you will see a + sign. Now move the cursor down.

DATEDIF function

6. NETWORKDAYS Function

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)

If you want to apply the syntax for your dataset. Just follow the below steps.

Steps:

  • Select the blank cell D3
  • Type the formula =NETWORKDAYS(C3, D3,$F$3:$F7) where C3 is the order date, D3 means today and F3:F7 are holidays.
  • Press Enter
  • Use Fill Handle Tool for filling up E4 to E7 cells

NETWORKDAYS Function

Conclusion

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


Further Readings

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo