Help

WORKDAY function but also includes the startDate in the count

Topic Labels: Dates & Timezones
Solved
Jump to Solution
1240 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')