Menu
This has been killing me for a while now. I just need to count a cell if the date in that cell is greater than or equal to a date in another cell (minus x days).
For example:
A1 2/20/2014
B1 1/20/2014
=COUNTIF(B1, ">=A1-30")
-30 would be minus 30 days. This obviously does not work. Help is greatly appreciated. Thanks!
679
The Excel COUNTIFS function returns the count of cells that meet one or more criteria. COUNTIFS can be used with criteria based on dates, numbers, text, and other conditions.
You were almost there:
=COUNTIF(B1, ">=" & A1-30)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
