Countif Formula With Beginning of The Month Till Today Date Range (Google Sheet)-CodePudding

Home > OS > Countif Formula With Beginning of The Month Till Today Date Range (Google Sheet)

Countif Formula With Beginning of The Month Till Today Date Range (Google Sheet)

Time：10-16

the objective of the formula is to count the number of certain dates from 1st of the month till today. Ex:

A1 10/5

A2 10/6

A3 10/11

A4 10/29

A5 10/20

Today is 10/14

I want to count the number of dates before today, which is 3. The formula I could come up with is as below, please tell me whats wrong with it.

=countif(A1:A5;">=TODAY()-30";A1:A5;"<=TODAY()")

Thanks in advance.

CodePudding user response：

Try below formula

=COUNTIF(A:A,"<" & TODAY())