Count if with dates

CAKutsh

I am trying to count new hires for 2022. My formula is =countif({Hire Date},=>Date(01,01,2022)), but it comes back unparsable, any ideas?

Genevieve P.

Hi @CAKutsh

The operators will need to be in a different order as well. When you're adding = to > or <, it should go after your greater than sign.

 =COUNTIF({Date of Hire}, >= Date(2022, 01, 01))

James Keuning

you are gonna love this:

DATE(2022, 1, 1)

CAKutsh

Thank you for your response. I typed in =COUNTIF({Date of Hire},=>Date(2022, 1, 1))and it is still unparsable - any ideas?

Genevieve P.

Hi @CAKutsh

The operators will need to be in a different order as well. When you're adding = to > or <, it should go after your greater than sign.

 =COUNTIF({Date of Hire}, >= Date(2022, 01, 01))

CAKutsh

Holy heck! Yes that worked, thank you! May I put you on speed dial ;)