Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

WORKDAY function but also includes the startDate in the count

Topic Labels: Dates & Timezones
Solved
Jump to Solution
1354 1
cancel
Showing results for 
Search instead for 
Did you mean: 
AISYAH_AMBOK
5 - Automation Enthusiast
5 - Automation Enthusiast

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:

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

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

See Solution in Thread

1 Reply 1
Kamille_Parks
16 - Uranus
16 - Uranus

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