Use a Calculate Days Between Dates action to calculate the number of days that have passed between two specified dates. You can configure how days are counted and even exclude specific dates, such as weekends and bank holidays.
Calculate days
Create an action and choose Calculate Days Between Dates. Select the start and end dates in the action configuration. The action node will output a number variable that contains the number of days between the start and end dates. If the end date is before the start date, the output number will be negative.
Include start and end date in counting
By default, the start date is not included in the count of days, but the end date is. However, you can configure whether they should be included or not by ticking the boxes next to the date input fields. If the start and end dates are the same, the number of days between them is always calculated as zero, regardless of the inclusion settings.
Skip dates
Additionally, you can choose to skip certain days when counting days between dates. You have the option to skip specific days of the week, such as Sundays, or manually add dates that should be skipped, like bank holidays in the relevant region. Skipped days are not counted when calculating the number of days.
Illustrated examples
Below, find examples of possible configurations and how days are counted.