Excel countif date in cell is greater than or equal to date in another cell

excel excel-2007 countif
user3334256 picture user3334256 · Feb 20, 2014 · Viewed 64.3k times · Source

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!

Answer

Dmitry Pavliv picture Dmitry Pavliv · Feb 20, 2014

You were almost there:

=COUNTIF(B1, ">=" & A1-30)

Related questions

How do I count not equal to wildcard characters in Excel?

Using COUNTIF(range,"<>") can I count non-empty cells and with COUNTIF(range,"~?") or COUNTIF(range,"~*") can I calculate the number of cells matching a wildcard character, but can I do it with one COUNTIF() ? COUNTIF(range,"<>~?") …

Read More
Append same text to every cell in a column in Excel

How can I append text to every cell in a column in Excel? I need to add a comma (",") to the end. Example: [email protected] turns into [email protected], Data Sample: [email protected] satishmm_2sptc@…

Read More
How to do a "Save As" in vba code, saving my current Excel workbook with datestamp?

I have an Excel Workbook that on form button click I want to save a copy of the workbook with the filename being the current date. I keep trying the the following ActiveWorkbook.SaveAs ("\\filePath\FormFlow To MSExcel\" & Left(…

Read More