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.
[TABLE="class: cms_table_grid, width: 500"]
<tbody>[TR]
[TD]Start Date[/TD]
[TD]End Date[/TD]
[TD]Funding[/TD]
[/TR]
[TR]
[TD]6/25/2012[/TD]
[TD]6/24/2015[/TD]
[TD]$200,000[/TD]
[/TR]
[TR]
[TD]1/1/2010[/TD]
[TD]12/31/2014[/TD]
[TD]$500,000[/TD]
[/TR]
[TR]
[TD]etc.[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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