# How to get a formula to count only workdays

Occasional Contributor

# How to get a formula to count only workdays

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

# Re: How to get a formula to count only workdays

Use WORKDAY.INTL().

# Re: How to get a formula to count only workdays

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

# Re: How to get a formula to count only workdays

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)`

# Re: How to get a formula to count only workdays

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

# Re: How to get a formula to count only workdays

That could be:

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