Skip to main content
Solved

WORKDAY function but also includes the startDate in the count

  • August 19, 2020
  • 1 reply
  • 1 view
A

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:

Best answer by Kamille_Parks11

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

View original
    Did this topic help you find an answer to your question?

    1 reply

    Kamille_Parks11
    Forum|alt.badge.img+25

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

    A
    1 person likes this
    • A
      AISYAH_AMBOK

    Reply


    Most helpful members this week

    Terms & Conditions