Finding if a date falls in a range in a referenced sheet

emilyc9

I am working in a separate sheet for calculating metrics. I want to count the number of items in a referenced date range in another sheet that meet certain year criteria. For example, I want to find the dates in the referenced range (a row defined as type DATE) that fall in calendar year 2023.

I am using:

=COUNTIF({P&M Requests Date Requested}, YEAR(@row)=2023)

I get an #UNPARSEABLE error.

P&M Requests Date Requested is a date column in another sheet. YEAR will not accept a range as an argument, so I am trying to grab each row (containing a full date) where the year is 2023.

Is there a way to do this that I am missing? I have been playing with variations on this formula for hours.

Thanks ahead of time for any help.

Emily

Nic Larsen

Try This:

=COUNTIFS({P&M Requests Date Requested}, IFERROR(YEAR(@cell), 0) = 2023)

Nic Larsen

Try This:

=COUNTIFS({P&M Requests Date Requested}, IFERROR(YEAR(@cell), 0) = 2023)

emilyc9

Thank you so much, works perfectly!