In the previous article, I showed you how to calculate the number of days, months and years between any two times in Excel with the DATEDIF function. However, there is still much reader feedback on complexity, as well as being difficult to use with this function formula.
Yes, because of that, today I will continue to share with you a similar function formula, but with a simpler structure. Help you to calculate the time between any two times is faster and more convenient.
#first. How to use the DAYS function to calculate the number of days between two dates in Excel
+ Step 1: First you open the Excel file to be processed.
+ Step 2: Then you click on the number of days in the worksheet, and enter the following formula => and press Enter for Excel to execute.
= DAYS(end date; start day)
Applied to the example we get the formula: = DAYS (A4; B4)
// That is, subtract the start date from the end date.
+ Step 3: Next, keep your mouse on the plus sign in the formula cell => and Fill it down to the whole list to be calculated.
To be the result of calculating the number of days.
#2. Calculate the number of weeks, months, quarters and years at two times in Excel
After calculating the number of days, you use the division formula to find the value of the week, month, quarter, year (equivalent to weeks 7, 30, 90, 365) ... using the formula below = > Then press Enter to execute:
= number of days/value to find
Then fill the formula down the whole list to apply the formula to the remaining cells.
And this is the result we have obtained.
# 3. Epilogue
With this calculation, you can calculate the number of days (or weeks, months, quarters, years) between the two times, similar to the DATEDIF function, but a lot easier already, right?
In addition, to make it easier to calculate and remove long decimal numbers, you can apply the previous article on how to round decimal numbers in Excel.
Yes ! Here comes the tutorial how Use the DAYS function to calculate the number of days between two dates in Excel I also would like to pause. Hope this tip will be helpful to you.
Good luck !
CTV: Luong Trung - Blogchiasekienthuc.com
Note: Was this article helpful to you? Do not forget to rate the article, like and share it with your friends and relatives!Read more :
- Basic guide to Advanced Custom Fields and how to use it
- Social Auto Poster v3.4.1 - Plugin that automatically posts to the social network WordPress Codecanyon
- What to do when denied life insurance compensation benefits
- ETH-based DEXs witnessed a surge in trading volume
- The number of Bitcoin wallet holdings of at least 1 BTC reaches an all-time high