#UNPARSEABLE

I am using the following formula to calculate the net days but only if the dates are listed. What am I doing wrong?

=IF(AND(ISDATE([Date Received]3085), ISDATE([Processing End Date]3085)), NETDAYS([Date Received]3085, [Processing End Date]3085), "")

Thank you much!

SS Screenshot.jpg

Find more posts tagged with

Formulas

Project Management

Comments

J. Craig Williams

The formula looks OK.

Do you have 3085 rows? If you don't, that is that error. The 3085 is the row reference.

Craig

Angie Hatfield

I figured it out. I just kept playing with it until it worked. Yes, this particular sheet has over 3085 rows, that's just the one I was working with. I also changed it to NETWORKDAYS.

I saved this to my frequently used SS. I imagine I will be using it a lot now.

Thanks for your help!

=IF(AND(ISDATE([Date Recieved]3085), ISDATE([Processing End Date]3085)), NETWORKDAYS([Date Recieved]3085, [Processing End Date]3085))