Counting rows with specific dates
Hi I am trying to count the number or rows with an August date from the following data 18/08/2023 18/08/2023 16/08/2023 15/08/2023 08/08/2023 04/08/2023 04/08/2023 02/08/2023...
NatashaTF But that's what's in your formula. Count the number of dates before August 1.
Use this in stead:
=COUNTIF(A1:A15,">=01/08/2023")
Or use COUNTIFS like this in case you explicitly want to set the upper and lower date limits.
=COUNTIFS(A1:A15,"<=31/08/2023",A1:A15, ">=01/08/2023")
