Aug 19, 2020 12:13 AM
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:
Solved! Go to Solution.
Aug 19, 2020 11:27 PM
Simplest way would probably be adding -1 days to your start date: DATEADD({Start Date}, -1, 'days')
Aug 19, 2020 11:27 PM
Simplest way would probably be adding -1 days to your start date: DATEADD({Start Date}, -1, 'days')