Count of a column between two dates

I'm trying to determine how many times we post for a hospital in each year. (Ex: ABC Hospital posted # times in 2022). The formula I'm using now is:

COUNTIFS({SS Hospital}, [Primary Column]@row, ({SS Posted}, >=DATE(2022, 1, 1), {SS Posted}, <=DATE(2022, 12, 31)))

SS Hospital references the column from a different sheet that the hospital names are in, Primary Column is the actual hospital name, and SS Posted references a different sheet our dates are in.


Tags:

Answers