• 579K Members
• 4,891 Online
• 701K Conversations

## 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
Highlighted

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

Use WORKDAY.INTL().

Highlighted

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

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

Highlighted

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

Highlighted

# 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
Highlighted

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

That could be:

`=IF(A4="";"";WORKDAY.INTL(A4, 5, 1, \$Z\$10:\$Z\$25))`
Related Conversations
SharePoint 2013 LIst Filters (by latest date)
dmphil in SharePoint on
0 Replies
Counting Days
Tim Hunter in SQL Server on
2 Replies
How to count multiple values in a cell
Ugarte335 in Excel on
7 Replies
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies