Date function, Need MM/YY *Note:Formatting will not work as sumproduct search

Now before you suggest formatting... Let me explain why that won't work

I am using a sumproduct that is searching for a MM/YY, if I just do formatting the date is still in there and I need it excluded...

So if the date is 04/12/13 I need the results returned as 04/13

Thanks!!

Not sure why you are saying that formatting will not work. Your sumproduct formula would contain
=SUMPRODUCT(--(TEXT($A$1:$A$100, "MM/YY")="04/13"), .....

However, if you are adamate about formatting as text, you could use the above in another column
i.e. in B2, = TEXT(B1,"MM/YY")
Please give more information if I am off the mark here (a spreadsheet always helps (Go Advanced> Manage Attachments))

Okay, the problem is that your headers on your Overall Table are not text, they are dates formatted as mm/yy. For example I1 is actually 4/19/2013.

I am assuming you want all dates that are in April 2013.
You could change your formula in I2 (modified so you can copy across and down)
=SUMPRODUCT((Sheet2!$C$3:$C$1595=$B2)*(Sheet2!$D$3:$D$1595=TEXT(I$1,"mm/yy"))*(Sheet2!$S$3:$S$1595))
or if you want to get rid of Column D in sheet2
=SUMPRODUCT((Sheet2!$C$3:$C$1595=$B2)*(TEXT(Sheet2!$D$3:$D$1595,"mm/yy") =TEXT(I$1,"mm/yy"))*(Sheet2!$S$3:$S$1595))

OR
you could change your header formulas
=TEXT(Edate(Today(),0),"mm/yy")

and modify the above formulas accordingly.
Any of this make sense?