countif ?
If date column is A:
=SUMPRODUCT(--(MONTH(A1:A10)=1))
Adjust range to the last row!
Regards,
Stefi
€˛joe@malvern€¯ ezt Ć*rta:
I would like to search and countif a column with dates (MM/DD/YYYY) counting
if the month is January "01". How do I do this
thanks
|