How to get a formula to count only workdays

Copper Contributor

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? 

5 Replies

@JanePeters_ 

Use WORKDAY.INTL().

 

@Detlef Lewin what would the formula look like? I've never used that before

 

Thank you in advance :) 

@JanePeters_ 

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)

 

Thankyou

I am not having troubles getting an if formula to work!

The cells that don’t have dates in my original column are coming up with 01/01/1900 how do I get this blank with the workday.intl formula included?

Thanks

@JanePeters_ 

That could be:

=IF(A4="";"";WORKDAY.INTL(A4, 5, 1, $Z$10:$Z$25))