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