COUNTIF AND for date

Jessica Griffin

Referencing when a column says HR and the date is this year

=COUNTIF({Intake Archival Range 1}, "HR", AND({Intake Archival Range 3}, >=DATE(2022, 1, 1)))

Any help appreciated!

RaffyM

Hello. Try this if will works.

=COUNTIFS({Intake Archival Range 1}, "HR", {Intake Archival Range 3}, @cell DATE(2022, 1, 1))

Tim Dollmeyer

Hi Jessica,

You would want to use the COUNTIFS function:

=COUNTIFS({Intake Archival Range 1}, "HR", {Intake Archival Range 3}, >=DATE(2022, 1, 1))

Hope this helps!

Jessica Griffin

@Tim Dollmeyer #incorrect argument

@RaffyM #unparseable

Any other ideas?