DAYS function - Microsoft Support
https://support.microsoft.com/en-us/office/days-function-57740535-d549-4395-8728-0f07bff0b9df
•If both date arguments are numbers, DAYS uses EndDate–StartDate to calculate the number o…•If either one of the date arguments is text, that argument is treated as DATEVALUE(date_text) and returns an integer date instead of a time component. •If date arguments are numeric values that fall outside the range of valid dates, DAYS returns th…•If date arguments are strings that cannot be parsed as valid dates, DAYS returns the #VALUE! error value.
•If both date arguments are numbers, DAYS uses EndDate–StartDate to calculate the number o…•If either one of the date arguments is text, that argument is treated as DATEVALUE(date_text) and returns an integer date instead of a time component.
•If date arguments are numeric values that fall outside the range of valid dates, DAYS returns th…•If date arguments are strings that cannot be parsed as valid dates, DAYS returns the #VALUE! error value.
DA: 12 PA: 59 MOZ Rank: 38