Pivot Table Filters

[Gra06021]

My data has two columns (a start date and an end date). I need to be able to select a date and see which projects were active at that time.

Start Date	End Date	Funding
6/25/2012	6/24/2015	$200,000
1/1/2010	12/31/2014	$500,000
etc.

<tbody>
</tbody>

For example with the data above how would I show what funding was available in 2013 in a pivot table?

Thanks!

 

[starl]

You can't. 2013 is not information available in the data set. Excel has no way of knowing your dates are a range. You would need a record (row) for each active year
But if you just want to summarize the funding in 2013, you could use a SUMIFS formula.

 

[Gra06021]

You can't. 2013 is not information available in the data set. Excel has no way of knowing your dates are a range. You would need a record (row) for each active year
But if you just want to summarize the funding in 2013, you could use a SUMIFS formula.

That's what I was thinking too... I was just hoping there would be a way to filter>=2012 AND <=2014, but for whatever reason that is pulling the right data either... thanks for your help Starl