Do I use CountIf to count the number of patients in any given month?

Robyn Pier

I can't find a formula that works to do a tally of how many patients I had in each month. Would I do a COUNT and then somehow determine it by month? Help please??? :)

L_123

=countif(date:date,month(@cell)=1)

will return all submissions for the month of january

=countif(date:date,and(month(@cell)=1,year(@cell) = year(today()))

will return all submissions for the month of january in the current year

Robyn Pier

It comes back unparseable?

=countif(date:date,month(Dates1=1)

L_123

=countif(date:date,month(Dates1)=1)

Robyn Pier

I'm sorry--I copy it exactly and it still says unparseable

So Dates is the first column, formatted as dates. Is that a problem? Should it not be a date column?