Help

Re: Count meeting dates that have passed without counting empty cells

363 0
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")