NETWORKDAYS

JT_22002

PROBLEM SOLVED THANK YOU

David Tutwiler

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

@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)