NETWORKDAYS

JT_22002
JT_22002
edited 08/02/23 in Formulas and Functions

PROBLEM SOLVED THANK YOU

Tags:

Answers

  • David Tutwiler
    David Tutwiler Overachievers Alumni

    It looks like you are pointing the formula to a reference sheet. If you are selecting a range (a whole column), then this will not work. NETWORK days is looking for 1 start date and 1 end date. It can't perform the function over a range.

    I would suggest, if possible, calculating the network days on the reference sheet and bringing that in, or creating a helper sheet than brings your two ranges together into a single sheet to run the calculation against.

  • JamesB
    JamesB ✭✭✭✭✭✭

    @JT_22002

    I am assuming that Visit Date and DATA RECEIVED are both date columns in the same sheet and the 35 and 42 are the row numbers you are trying to reference. If this is correct then your formula should be:

    =NETWORKDAYS([Visit Date]13,[DATA RECEIVED]42)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!