Comment on page
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.
days(date, date)
number
days(start, end)
To return the number of days between 2 given dates.1
days(date1, date2)
date1 = 07/02/2021 and date2 = 12/31/2021 (US)
Result: 183 (days until New Year’s Eve)
Last modified 1yr ago