SUMIFS formula not working with =TODAY()-1

[Stenner]

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.

[TMS]

Try:

Please Login or Register  to view this content.

Regards, TMS

[Stenner]

Brilliant! thank you

[TMS]

You're welcome.