How to get a formula to count only workdays

Question

Hi,&nbsp;I have a spreadsheet that I need to automatically calculate a due date but it can only include workdays.&nbsp;&nbsp;Can anyone please give me a suggestion on this?&nbsp;&nbsp;In my image you will see the following columns&nbsp;Drafting Due Date - needs to be 10 business days from the CT requested DateDraftaway Due Date - needs to be 5 business days from the Sent to Draftaway Date&nbsp;Can this be done?&nbsp;

detlef_lewin · Answer

JanePeters_&nbsp;Use WORKDAY.INTL().&nbsp;

janepeters_ · Answer

Detlef_Lewin&nbsp;what would the formula look like? I've never used that before&nbsp;Thank you in advance :)&nbsp;

detlef_lewin · Answer

JanePeters_&nbsp;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)&nbsp;

janepeters_ · Answer

ThankyouI 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

detlef_lewin · Answer

JanePeters_&nbsp;That could be:=IF(A4="";"";WORKDAY.INTL(A4, 5, 1, $Z$10:$Z$25))

Forum Discussion

How to get a formula to count only workdays

5 Replies

Resources