Both dates must bevalid Excel datesor text values that can be coerced to dates.
The DAYS function only works with whole numbers, fractional time values that might bepart of a dateare ignored.
If start and end dates are reversed, DAYS returns a negative number.
The DAYS function returnsall daysbetween two dates, to calculateworking daysbetween dates, see theNETWORKDAYS function.
For example:
The DAYS function returns the number of daysbetweentwo dates.
Working with nativeExcel dates(which are numbers) is a better approach.
To create a numeric date from scratch in a formula, use theDATE function.
For example, the formula =DAYS360(“1-Jan-2021”,“31-Dec-2021”) returns 360 days.
NETWORKDAYS Function
The Excel NETWORKDAYS function calculates the number of working days between two dates.
NETWORKDAYS automatically excludes weekends (Saturday and Sunday) and canoptionallyexclude a list of holidays supplied as dates.
…
NETWORKDAYS.INTL Function
The Excel NETWORKDAYS.INTL function calculates the number of working days between two dates.
