Whys is TODAY(-90) returning values for future dates


I am trying to sum the # of PTO hours an employee has used in the last 90 days for some reason my formula =SUMIFS({Missed Hours}, {TM}, $Name@row, {Type}, PTO$1, {Date}, >=TODAY(-90), {Cancel}, 0) is tallying all of the time off requested even for future dates. I would expect the value returned to be 56 however it is returning the total of 168.

Thanks In Advance for any help provided!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!