Introduction to DAYS Function
DAYS function returns the difference between two dates. It takes a start date and an end date and then returns the difference between them in days. This function was introduced in Excel 2013 so not available in prior versions.
Download Sample File
Download Sample Files to work, practice and master the Date Functions in Excel.
Syntax of DAYS Function
DAYS(end_date,start_date)
Arguments of DAYS Function
- start_date: It is a valid date from where you want to start the days’ calculation.
- end_date: It is a valid date from where you want to end the days’ calculation.
Example of DAYS Function in MS Excel
In the below example, we have referred the cell A1 as the start date and B1 as the end date and we have 9 days in the result.
Note: You can also use the subtract operator to get the difference between two dates.
In the below example, we have directly inserted two dates into the function to get the difference between them.
Other Excel Date Functions Tutorials
You can explore and master other date functions in Microsoft Excel. Here is a complete list of date functions available in Microsoft Excel.
