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?
@Detlef Lewin what would the formula look like? I've never used that before
Thank you in advance :)
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)
That could be:
=IF(A4="";"";WORKDAY.INTL(A4, 5, 1, $Z$10:$Z$25))