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.
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.
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
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.
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
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.
Read More: How to Count Days from Date to Today Automatically Using Excel Formula
Similar Readings
- How to Calculate Working Days in a Month in Excel (4 Easy Ways)
- [Fixed!] VALUE Error (#VALUE!) When Subtracting Time in Excel
- How to Calculate Years Between Two Dates in Excel (2 Methods)
- Add Dates in Excel Automatically (2 Simple Steps)
- How to Count Months in Excel (5 ways)
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.
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.
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
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.
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:
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.
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.
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.
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
- How to Count Months from Date to Today by Using Excel Formula
- Excel Formula to Find Date or Days for Next Month (6 Quick Ways)
- How to Calculate Number of Months Between Two Dates in Excel
- Calculate Years and Months between Two Dates in Excel (6 Approaches)
- How to Add Days to a Date in Excel Excluding Weekends (4 Ways)