Count the number of lines after a date.

Christophe AUBRIOT ✭✭

09/29/21 in Formulas and Functions

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.

0 · Share on FacebookShare on Twitter

Best Answer

• 

  Jason Albrecht ✭✭✭✭✭✭

  10/01/21 Answer ✓

  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?

  Hope this helps and that you have a great day,

  Jason Albrecht MBA, MBus(AppFin), DipFinMgt

  LinkedIn profile - Open to work

  1 · Share on FacebookShare on Twitter

Answers

• 

  Jason Albrecht ✭✭✭✭✭✭

  10/01/21 Answer ✓

  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?

  Hope this helps and that you have a great day,

  Jason Albrecht MBA, MBus(AppFin), DipFinMgt

  LinkedIn profile - Open to work

  1 · Share on FacebookShare on Twitter

Sign in

Try Smartsheet

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list