Count the number of lines after a date.

Christophe AUBRIOT

Hello.

Certainly a simple question for all of you, but not for me!

I am trying to count how many rows were created after a certain date.

For example: 

=COUNTIF({PDCA Commercial SLF-FP-001 Range 3}; > 01/01/2020).

Thanks in advance.

Jason Albrecht

Hi @Christophe AUBRIOT

I would couch the criterion within a DATE function. e.g.

=COUNTIF({PDCA Commercial SLF-FP-001 Range 3}; > DATE(2020, 01, 01)

Hope this helps?

Jason Albrecht

Hi @Christophe AUBRIOT

I would couch the criterion within a DATE function. e.g.

=COUNTIF({PDCA Commercial SLF-FP-001 Range 3}; > DATE(2020, 01, 01)

Hope this helps?