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 updated