Skip to main content

Count meeting dates that have passed without counting empty cells

  • September 2, 2021
  • 1 reply
  • 8 views

Trying to count meeting dates that have passed, but it keeps counting empty cells. Can someone help or offer a better solution?

IF({Meeting Date} <= TODAY(), “Yes”

1 reply

Kamille_Parks11
Forum|alt.badge.img+27

Try:

IF(AND({Meeting Date}, {Meeting Date} <= TODAY()), "Yes")