Having formula only apply to certain fields over a large data set in Pivot Table

[TexasHeat]

So I have a very large data set; something like 14,000 rows. I'm trying to apply a date formula that gives me the value between the date listed in my pivot table and another date I have in order to find me the gap between. The problem is since I want to just paste this formula across ll 14,000, it's throwing back a lot of misinformation since it's applying the formula to everything. Is there a way to use conditional formatting or something in order to only apply the date formula to the dates and omit the other information?





[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 327"]
<tbody>[TR]
[TD]Row Labels[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12497290[/TD]
[TD]Days Between Fueling[/TD]
[/TR]
[TR]
[TD]12497290 PU 1/2 T 2X4 CRW CAB[/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
[TR]
[TD] 01/06/2015[/TD]
[TD="align: right"]19[/TD]
[/TR]
[TR]
[TD]Lance Songy[/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
[TR]
[TD]419543[/TD]
[TD="align: right"]377552[/TD]
[/TR]
[TR]
[TD] 01/13/2015[/TD]
[TD="align: right"]26[/TD]
[/TR]
[TR]
[TD]Lance Songy[/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
[TR]
[TD]865619[/TD]
[TD="align: right"]823628[/TD]
[/TR]
[TR]
[TD] 03/02/2015[/TD]
[TD="align: right"]74[/TD]
[/TR]
[TR]
[TD]Lance Songy[/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
[TR]
[TD]419543[/TD]
[TD="align: right"]377552[/TD]
[/TR]
[TR]
[TD] 03/24/2015[/TD]
[TD="align: right"]96[/TD]
[/TR]
[TR]
[TD]Lance Songy[/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
[TR]
[TD]929487[/TD]
[TD="align: right"]887496[/TD]
[/TR]
[TR]
[TD] 04/13/2015[/TD]
[TD="align: right"]116[/TD]
[/TR]
[TR]
[TD]Lance Songy[/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
[TR]
[TD]417711[/TD]
[TD="align: right"]375720[/TD]
[/TR]
[TR]
[TD] 04/24/2015[/TD]
[TD="align: right"]127[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[scottsen]

This looks like you have your data just... setup kinda weird, with multiple "types" of data all in 1 column. Also, if you are just doing "normal" pivot table stuff, you might hit the main excel forum, as the answers for Power Pivot will be different.