Date Format Formula

My org has a sheet that logs work orders by date received. The date format is 01-03-2022 08:47:13 AM.

I have formulas on another sheet to count the total number of work orders per quarter.

=COUNTIFS({WO Log Range 2}, AND(@cell >= DATE(2023, 1, 1), @cell <= DATE(2023, 3, 31)))

The formulas aren't working. I think it's because of the format used in the Date WO Created column but I can't change the format, it's used by other depts.

Is there a work around to this or is my formula wrong?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!