Hi All

I am currently using a SUMIFS forumla to get data from another TAB.

Its currently =SUMIFS('Finishing Report'!G:G,'Finishing Report'!B:B,J24,'Finishing Report'!C:C,K24,'Finishing Report'!A:A,"=TODAY()-1")

This comes up a 0, however if I take out the =today forumla it comes up with 7481.

I am using a recognisable date format in the Finishing Report Tab, I really can't see where I've gone wrong because I have done this formula mulitple times in the past.