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(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)