Skip to main content

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! :grinning_face_with_smiling_eyes:

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


Reply