#Num! Error in Pivot table

[Ruthafurd]

So I am getting an error from a networkdays formula, but only in one field of my pivot table. All the Data is the same format and every other field is working. I look there are not data errors in the range that it is looking for any ideas?

 

[Derek Brown]

Hello and welcome to The Board.
Do you mean 'pivot' table or should it just be 'table'?
It may help if you can show the formula that is being used together with the actual dates that should be used in the cell that is giving the error.
The error that you gave indicates that at least one of the values is not being seen as a date (dates are held in Excel as a number - the number of days since 01/01/1900).

 

[Ruthafurd]

I mean pivot table.

The formula is =(Networkdays(scheduleddate,targeteddate)/5)/3. there are a is a list of about 200 scheduled and 200 targeted that it is pulling from all dates are in the correct range, so no start dates are after end dates or end dates before start dates. could it be the number is to big to calculate.

 

[Derek Brown]

So to make sure that I understand what you have:
Your pivot table has a column titled "scheduleddate" and another titled "targeteddate" and you are getting just the one error with all the other Networdays formulas working correctly?
Can you say what two dates are being used in the one that is failing?
Also, which version of Excel is being used?