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.
