Search…
Resources
Related Links
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.
days(date1, date2)
‌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 modified 2mo ago
Export as PDF
Copy link