Forum Discussion

JanePeters_'s avatar
JanePeters_
Copper Contributor
Apr 02, 2019

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...
excel
JanePeters_'s avatar
JanePeters_
Copper Contributor
Apr 02, 2019

Detlef_Lewin what would the formula look like? I've never used that before

 

Thank you in advance :) 

  • JanePeters_'s avatar
    JanePeters_
    Copper Contributor
    Apr 02, 2019
    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
    • Detlef_Lewin's avatar
      Detlef_Lewin
      Silver Contributor
      Apr 02, 2019

      JanePeters_ 

      That could be:

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

Resources