This post will guide you how to use Excel DAYS function with syntax and examples in Microsoft excel.
The Excel DAYS function returns the number of days between two dates.
The DAYS function is a build-in function in Microsoft Excel and it is categorized as a DATE and TIME Function.
The DAYS function is available in Excel 2016, Excel 2013.
The syntax of the DAYS function is as below:
= DAYS (end_date,start_date)
The below examples will show you how to use Excel DAYS Function to return the number of days between end_date and start_date.
#1 =DAYS (B2,B1)
Note: the above excel formula retruns the number of days (372) between the end date (7/2/2017) and start date (6/25/2016).