This is the code I have. Basically I need to count the total number of cells containing a date that is less than today as well as count all the blank cells. The problem I have is with the blank cells. The beginning of the formula is counting the dates accurately..![]()
=countif(next,"<"&today())+countif(next,"=&""")
Thanks for the help!
Bookmarks