How to do a date range in SMartsheets

This formula works in excel but won't work in smartsheets How would I write it

=SUMIFS({pMPS Active Cancelations Range 3}, {pMPS Active {pMPS Active Cancelations Range 1}Range 1,"Page",{pMPS Active Cancellation Range 4},">="&Date(11/1/21),{pMPS Active Cancellation Range 4},"<="&Date(10/31/22}))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!