WORKDAY function but also includes the startDate in the count

Hi! I would like to use the WORKDAY function to count the number of working days from an input date, but I would also like to include the input date as well.

For example, if I count 6 working days from 19-Aug, the WORKDAY formula would count until 27-Aug.
However, I want 19-Aug to be included in those 6-days – so by right, 6-working days from 19-Aug, including 19-Aug itself, should be 26-Aug.

How do I include that in a formula?

Thanks in advance for any help! :smile:

Simplest way would probably be adding -1 days to your start date: DATEADD({Start Date}, -1, 'days')

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.