How to calculate the number of days in Excel

Why does taking days count make users headaches? If only calculating a short period of time is quite simple but a 7-day, a month with an irregular number of days and irregular leap years is indeed a problem.

How many days from January 9, 2015 to June 12, 2017? If you can find results within 5 seconds, you are truly a genius. However, this is no longer a problem when you know how to use Excel.

Calculate the number of days and months between any time

On the Excel spreadsheet, set any 2 days you want to calculate on 2 separate cells.

Here are a few sample equations. Check the box where you want to display the answer and enter one of the following commands (remember to replace the cell addresses that match your Excel table):

Calculate the number of days: = DATEDIF (D2, E2, 'd')

Calculate the number of weeks: = DATEDIF (D2, E2, 'd') / 7

Calculate the number of months: = DATEDIF (D2, E2, 'm')

Calculate the number of years: = DATEDIF (D2, E2, 'y')

Enter the command you need to enter into the answer box. For example, if we want to calculate the date, we enter the command = DATEDIF (D2, E2, 'd')

How to calculate the number of days in Excel Picture 1

Calculate the cumulative time between any 2 days

We already know how to calculate the total number of days, months and years but what if we want to calculate the total cumulative time in the form of "day, month, year"?

We need to combine the equations above. Put the calculation function below in the box to enter the answer and press Enter:

= DATEDIF (D2, E2, 'y') & 'years,'
& DATEDIF (D2, E2, 'ym') & 'months,'
& DATEDIF (D2, E2, 'md') & 'days'

How to calculate the number of days in Excel Picture 2

Note: Press Alt + Enter to add a new line and Ctrl + Shift + U to expand the cell and see the whole calculation function.

  1. How to combine 2 columns Full name in Excel does not lose content
  2. How to arrange incremental dates in Excel
  3. How to delete data, duplicate content in Excel

Have you ever used Excel to calculate dates? Do you know any other calculation method? Please share with us by commenting below!

4.5 ★ | 2 Vote

May be interested

  • The DAYS function - The function returns the number of days between 2 dates in ExcelThe DAYS function - The function returns the number of days between 2 dates in Excel
    days function: the function returns the number of days between 2 dates, the support function from excel 2013 onwards. syntax: days (end_date, start_date)
  • The easiest way to calculate the percentage (%)The easiest way to calculate the percentage (%)
    calculating percentages on excel doesn't have to use excel functions, it's just a normal calculation. so how to calculate the fastest percentage, and also need the most accurate. the following article will guide you how to calculate the most accurate percentage value.
  • Round a number in Excel (ROUND function)Round a number in Excel (ROUND function)
    instructions on how to round numbers in excel, help calculate faster depending on how to round the number of digits after and before the comma, there are many number rounded functions in excel. 1. round a number using the round () function - meaning: rounds to the nearest number
  • ABS function (absolute value calculation) in ExcelABS function (absolute value calculation) in Excel
    when you need to calculate absolute values ​​for numbers in excel spreadsheets, you can use the abs function to calculate. the abs function helps you calculate the absolute value of a number, an expression or reference containing a number.
  • 3 ways to calculate totals in Excel3 ways to calculate totals in Excel
    to calculate totals on excel, users can use them in three different ways, based on spreadsheets, autosum functions or sum functions with large data areas.
  • How to calculate time in Excel: Add and subtract timeHow to calculate time in Excel: Add and subtract time
    excel can calculate the amount of time by adding / subtracting method to give you the result of the amount of time in minutes, hours, days, and months. the following software tips will guide you the most basic formulas. the problem is that you have time to complete two steps of work, and you want to know how many hours and minutes it will take to complete the job.
  • Calculate the total value of the filtered list in ExcelCalculate the total value of the filtered list in Excel
    filter is a very useful and easy to use feature in microsoft excel. with filters, you can quickly limit data to only show the necessary information. however, how to calculate the total value of the filtered list? the following article will help you answer the above question.
  • SUM function in Excel: How to use SUM to calculate totals in Excel - SUM function in ExcelSUM function in Excel: How to use SUM to calculate totals in Excel - SUM function in Excel
    the sum function in excel is quite commonly used. below are details on how to calculate the sum function and related issues in microsoft excel.
  • Calculation of percentages in ExcelCalculation of percentages in Excel
    calculating percentages in excel is a basic calculation, with a very simple and quick calculation when you don't need to enter any functions.
  • Calculate the subtotal of the list on ExcelCalculate the subtotal of the list on Excel
    if you don't want to calculate subtotals, the list is a new feature that is very useful in excel 2003; excel always disables the subtotal feature for the list. currently, to be able to manage the list and perform calculations on the total number of dependencies & igr