Countif with Date Criteria

[BlueRhinos]

Is there a way to count cells if the date populated is equal to or less than a defined date? if so, can somone provide the syntax?

Thanks!

blue rhino

 

[c_m_s_jr]

Assuming your dates are in column A and they are to be evaluated against the date in B1:

=COUNTIF(A2:A100,"<="&B1)

 

[BlueRhinos]

thanks so much! What is the ampersand doing?

 

[Scott Huish]

It is the concatenation operator, so it is appending the value of B1 to the end of the <=