Days Between Two Dates

[MRovi]

I'm using a simple formula to subtract one date from the other to get the number of days in-between. I get a negative number for some of these that are missing dates. The dates will be filled in later. Is there a way to "ignore" the negative numbers for pivot tables and charts?

 

[NeonRedSharpie]

You could use an if statement:

=IF(Date1 - Date2 >= 0, Date1 - Date2, "To Be Completed")

and then filter out the "To Be Completed" entries.

 

[MRovi]

Perfect! Thank You!!!

 

[MRovi]

I spoke too soon. The pivot table still shows the negative numbers.

 

[NeonRedSharpie]

I spoke too soon. The pivot table still shows the negative numbers.

Is your pivot table using a calculated field?