YTD Count Based on Open Date

Robert_PM

Hello,

I am struggling to get a count of items that have been requested in the current year. I have been going through all the different posts and below is the formula I came up with to count all items that have been requested in the current year. When I run the formula I am getting 0. The dates are populated from a form and the column is set to the date format.

=COUNTIF({Date Requested}, IFERROR(YEAR({Date Requested}), 0) = YEAR(TODAY()))

Kelly Moore

Hey @Robert_PM

Try this

=COUNTIF({Date Requested}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))

Kelly

Kelly Moore

Hey @Robert_PM

Try this

=COUNTIF({Date Requested}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))

Kelly

Robert_PM

@Kelly Moore - that worked like a charm!!! I was super close :) thank you for the amazing assistance.

Kelly Moore

Hey Robert

You were super close! All it needed was a small tweak! As written, your formula was trying to compare the entire range, as a single instance, and asking if the entire range was equal to Today's year. The @cell allows you to ask the question as you had intended, cell by cell.

Kelly