COUNTIF for a date range - what am I doing wrong?

Hi all,

Is there something wrong with this formula? I just want to count how many rows fall in each financial year, and I can't tell what I've done wrong.

=COUNTIF ([Date of Request]:[Date of Request], (@cell >=DATE (2022, 4, 1), @cell <=DATE (2023, 3, 31)))

On a side note, didn't I read something about formula AI? I can't locate that anywhere!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!