COUNTIF specific date

Emilia125

Please can you help with a formula to count how many times on another sheet (B Shift List) the date in the column is within August.

Paul Newcome

You would use something along the lines of

=COUNTIFS({Source Sheet Date Column}, AND(IFERROR(MONTH(@cell), 0) = 8, IFERROR(YEAR(@cell), 0) = 2024))

Paul Newcome

You would use something along the lines of

=COUNTIFS({Source Sheet Date Column}, AND(IFERROR(MONTH(@cell), 0) = 8, IFERROR(YEAR(@cell), 0) = 2024))

Emilia125

Thank you @Paul Newcome, worked a treat!

Paul Newcome

Happy to help. 👍️