Why is this formula #invalid operation

RickyT · 01/17/24

=COUNTIFS(Flight:Flight, "FSC", [Date of Award]:[Date of Award], >1 / 1 / 2023, [Date of Award]:[Date of Award], <3 / 30 / 2023)

If I put the dates in parenthesizes it yeilds 0 even though I have "FSC" in the Flight column. If I take them away it becomes #invalid.

Nic Larsen · 01/17/24

Try it with the Date function:

=COUNTIFS(Flight:Flight, "FSC", [Date of Award]:[Date of Award], > DATE(2023, 1, 1), [Date of Award]:[Date of Award], < DATE(2023, 3, 30)

Nic Larsen · 01/17/24

Try it with the Date function:

=COUNTIFS(Flight:Flight, "FSC", [Date of Award]:[Date of Award], > DATE(2023, 1, 1), [Date of Award]:[Date of Award], < DATE(2023, 3, 30)

juliesilverio · 01/17/24

Hi Ricky,

I believe it is because of your date formatting. I would try the below:

=COUNTIFS([Flight]:[Flight] "FSC", [Date of Award]:[Date of Award], AND(@cell >= DATE(2023, 01, 01), @cell <= DATE(2023, 03, 31)))

Hope that helps!

Formulas and Functions