Home

How to get a formula to count only workdays

%3CLINGO-SUB%20id%3D%22lingo-sub-392707%22%20slang%3D%22en-US%22%3EHow%20to%20get%20a%20formula%20to%20count%20only%20workdays%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-392707%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20spreadsheet%20that%20I%20need%20to%20automatically%20calculate%20a%20due%20date%20but%20it%20can%20only%20include%20workdays.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20please%20give%20me%20a%20suggestion%20on%20this%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20my%20image%20you%20will%20see%20the%20following%20columns%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDrafting%20Due%20Date%20-%20needs%20to%20be%2010%20business%20days%20from%20the%20CT%20requested%20Date%3C%2FP%3E%3CP%3EDraftaway%20Due%20Date%20-%20needs%20to%20be%205%20business%20days%20from%20the%20Sent%20to%20Draftaway%20Date%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20this%20be%20done%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-392707%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-393301%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20get%20a%20formula%20to%20count%20only%20workdays%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-393301%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F285790%22%20target%3D%22_blank%22%3E%40JanePeters_%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20could%20be%3A%3C%2FP%3E%3CPRE%3E%3CSPAN%3E%3DIF(A4%3D%22%22%3B%22%22%3BWORKDAY.INTL(A4%2C%205%2C%201%2C%20%24Z%2410%3A%24Z%2425))%3C%2FSPAN%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-392829%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20get%20a%20formula%20to%20count%20only%20workdays%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-392829%22%20slang%3D%22en-US%22%3EThankyou%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20not%20having%20troubles%20getting%20an%20if%20formula%20to%20work!%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20cells%20that%20don%E2%80%99t%20have%20dates%20in%20my%20original%20column%20are%20coming%20up%20with%2001%2F01%2F1900%20how%20do%20I%20get%20this%20blank%20with%20the%20workday.intl%20formula%20included%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-392739%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20get%20a%20formula%20to%20count%20only%20workdays%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-392739%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F285790%22%20target%3D%22_blank%22%3E%40JanePeters_%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fworkday-intl-function-a378391c-9ba7-4678-8a39-39611a9bf81d%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ETake%20a%20look%20at%20the%20support%20page.%3C%2FA%3E%3C%2FP%3E%3CP%3EOr%20search%20for%20a%20tutorial.%3C%2FP%3E%3CP%3E%3CSPAN%3EIt%20could%20be%20like%20this%3A%3C%2FSPAN%3E%3C%2FP%3E%3CPRE%3E%3CSPAN%3E%3DWORKDAY.INTL(A4%2C%205%2C%201%2C%20%24Z%2410%3A%24Z%2425)%3C%2FSPAN%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-392735%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20get%20a%20formula%20to%20count%20only%20workdays%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-392735%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3E%40Detlef%20Lewin%3C%2FA%3E%26nbsp%3Bwhat%20would%20the%20formula%20look%20like%3F%20I've%20never%20used%20that%20before%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-392732%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20get%20a%20formula%20to%20count%20only%20workdays%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-392732%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F285790%22%20target%3D%22_blank%22%3E%40JanePeters_%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUse%20WORKDAY.INTL().%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
JanePeters_
Occasional 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))
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
ChirmyRam in Discussions on
3 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies