Matrics on a Created date

Htauber

Hi all,

I want to create a formula that counts all cells that were created after a date.

but the range should look up a create date type of column.

Based on another cell which has a date

Meaning in column4 I want to count cells that are in coulmn5 that are after the date on Date2

Paul Newcome

You would use something like this:

=COUNTIFS([Column 5]:[Column 5], @cell>= Date2)

Htauber

I tried that, but it didn't work, so my workaround, I did, I created another Date Column and =created date Column so I got a data column with the same data as the created Column.

and then the formula worked, I'm assuming I cannot run a formula of a created date with a condition of regular data Column

Paul Newcome

You can run a COUNTIFS on a created date type column. I do it pretty frequently actually.