I cannot get a SUMIF equation to properly calculate between a date range.

My equation is the following:

=SUMIFS([June 2024]188:[June 2024]263, [Revised Budget]188:[Revised Budget]263, >="01/01/24", [Revised Budget]188:[Revised Budget]263, <="01/31/24")

The equation seems to not recognize the year in the Criteria, so all January dates it includes in the SUM without reference to the year.

These columns are setup as Text/Number, so I am unsure if that is causing an issue.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!