days
To return the number of days between 2 dates
With this function, you calculate the number of days between 2 date values. All days of the week count, i.e. Monday until Sunday. All data types that contain a date can be used.
The function is handy to determine and check deadlines, periods, and due dates.
Syntax
days(date, date)
Return
number
Examples
days(start, end) To return the number of days between 2 given dates.
date1 = 07/02/2021 and date2 = 12/31/2021 (US)
Result: 183 (days until New Year’s Eve)
See also
workdays, which returns the number of workdays (Monday – Friday) between 2 dates.
Last updated