Help

Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Count meeting dates that have passed without counting empty cells

643 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Ying_Lin
4 - Data Explorer
4 - Data Explorer

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 1

Try:

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