Apr 01 2019 06:43 PM
Hi,
I have a spreadsheet that I need to automatically calculate a due date but it can only include workdays.
Can anyone please give me a suggestion on this?
In my image you will see the following columns
Drafting Due Date - needs to be 10 business days from the CT requested Date
Draftaway Due Date - needs to be 5 business days from the Sent to Draftaway Date
Can this be done?
Apr 01 2019 08:58 PM
Apr 01 2019 09:11 PM
Apr 01 2019 09:44 PM
Take a look at the support page.
Or search for a tutorial.
It could be like this:
=WORKDAY.INTL(A4, 5, 1, $Z$10:$Z$25)
Apr 02 2019 01:21 AM
Apr 02 2019 12:49 PM