How to calculate the number of days in Excel - Functions, formulas for calculating the number of days in Excel

In the process of processing data in Excel, you will certainly encounter many cases that need to calculate the number of days such as the number of days guests stay, the number of days to perform the job . it will be difficult if you do not know how to calculate. number of days in Excel. So please refer to the following article to know the function, the formula for calculating the number of days in Excel.

How to calculate the number of days in Excel - Functions, formulas for calculating the number of days in Excel Picture 1

The following article shows you how to calculate the number of days in Excel and the function of calculating the number of days in Excel, please follow along.

How to calculate days in Excel

Excel stores dates as values ​​(serial numbers) consecutively for use in calculations. Nature of dates in Excel: January 1, 1900 has a value of 1, October 30, 2018 has a value of 43403. That means each day in Excel will have a value of 1.

To see the value of the day you can use the function = DATEVALUE ('date')

1. Example = DATEVALUE ('30 / 10/2018 ')

How to calculate the number of days in Excel - Functions, formulas for calculating the number of days in Excel Picture 2

So to calculate the number of days in Excel you just need to subtract two values ​​of the two days to calculate the number of days to produce. You compute the following simple example:

1. Calculate the number of days of January 1, 2018 and January 15, 2018

The value of January 1, 2018 is 43101

The value of January 15, 2018 is 43115

1. So the number of days of the two days is 43115 - 43101 = 14 days.

How to calculate the number of days in Excel - Functions, formulas for calculating the number of days in Excel Picture 3

In addition, you can use functions and formulas in Excel to quickly calculate the number of days:

Functions, formulas for calculating the number of days in Excel

To calculate the number of days in Excel, you use the DAYS function, the syntax and how to use the DAYS function, you will find out below.

Description

Returns the number of days between two dates

Syntax

= DAYS (end_date; start_date)

In the function, there are two required arguments:

1. end_date (end date) and start_date (start date) are two days that you want to know how many days are between them.

Note:

1. Start_date and end_date are both numeric values, and DAYS will take the value of end_date minus start_date.
2. The DAYS function will return the #NUM! Error value . If the start_date and end_date arguments are numeric values ​​outside the range of valid dates.
3. The function returns the value #VALUE! if the start_date and end_date arguments are strings that cannot be parsed are valid dates.

For example

Calculate the number of days between May 1, 2018 and October 9, 2018.

You enter the function = DAYS ('09 / 10/2018 ';' May 1, 2018 '), note the date if you enter directly into the function, you need to enclose quotes''.

How to calculate the number of days in Excel - Functions, formulas for calculating the number of days in Excel Picture 4

Or you can refer to the cell containing the date as follows:

How to calculate the number of days in Excel - Functions, formulas for calculating the number of days in Excel Picture 5

Above is how to calculate the number of days in Excel, the function - formula to calculate the number of days in Excel. So from now on, if you need to calculate the number of days in Excel, you can easily calculate the number of days with the DAYS function. Hope this article will help you. Good luck!