The DAYS function - The function returns the number of days between 2 dates in Excel
The following article introduces you to the DAYS function - one of the functions in the date and time group is very popular in Excel.
Description: The function returns the number of days between 2 dates, the support function is from Excel 2013 version onwards.
Syntax: DAYS (en d_date, start_date)
Inside:
- end_date: The start date to calculate the number of days, is a required parameter.
- start_date: End date to calculate the number of days, is a required parameter.
Attention:
- If both end_date and start_date are numeric -> the function uses EndDate – StartDate to calculate the number of days between two dates.
- If one of the arguments end_date and start_date is text, it takes the date value via the DATEVALUE (date_text) function.
- If 1 of the 2 arguments end_date and start_date is outside the valid range of the day -> the function returns the #NUM! Error value
- If 1 of the 2 arguments end_date and start_date cannot be parsed into a valid date -> the function returns the #VALUE! Error value
For example:
Calculate the number of days between the following dates according to the description table:
- In the cell to calculate enter the formula: = DAYS (F7, I7).
- Press Enter -> The total number of days between the 2 days above is:
- Similarly copying the formula for the remaining values results:
- In case of entering the wrong date value -> function returns the error value #VALUE!
Here the month / day / year format because the wrong month value is 15, the function returns the #VALUE! Error value .
Above are instructions and some specific examples when using the DAYS function in Excel.
Good luck!
You should read it
- DAYS360 function - The function returns the number of days between 2 dates, based on 360 days in Excel
- NETWORKDAYS function - The function returns the number of whole working days between 2 dates in Excel
- NETWORKDAYS.INTL function - The function returns the number of whole working days between 2 dates, specifying weekends in Excel
- YEARFRAC function - The function returns the fifth calculated by the number of whole days between two specific dates in Excel
- DATEDIF function - The function calculates the number of days, months, years between 2 dates in Excel
- DAYS function, how to use the function to calculate the number of days between two time points in Excel
- The WORKDAY function - The function returns a date before or after the start date of a number of working days in Excel
- How to calculate the number of days in Excel
- DAYS360 function - The function finds the number of days between two dates based on a 360-day year in Excel
- The WORKDAY.INTL function - The function returns a date before or after the date starting with a custom weekend in Excel
- Wings calculates the number of days, the difference between two dates in Excel
- Coupdays function - Calculates the number of days in a coupon period and contains the settlement date in Excel
May be interested
DAYS360 function - The function returns the number of days between 2 dates, based on 360 days in Excel
EDATE function - Add and subtract months to a specified date in Excel
EOMONTH function - The function returns the last day in the month before or after 1 day of a specified number of months in Excel
HOUR function - The function returns the hour of a time value in Excel
ISOWEEKNUM function - The function returns the ordinal number of the year of the week that contains the given date in Excel
MINUTE function - The function returns minutes of a time value in Excel