TODAY Function randomly stopped working in my Summary Metric formulas, how do I fix?
In a SUMIFS function I am using a date check to sum all cells that have an expiry date equal or greater than TODAY: =SUMIFS(Expiry:Expiry, >=TODAY())
This worked for over a year but suddenly is giving an error message, any idea if something in the TODAY function changed?
Help Article Resources
Check out the Formula Handbook template!