Hi everyone,
I know the normal formula for COUNTIF AND COUNTIFS, but I'm trying to get Excel to count the number of cells in a range that contain ANY date. The range of cells would either create the word "Pending", be empty, or have a date in it. I want it to count the cells in the range with the date. I already have my formula for cells that contain "Pending" ... just can't figure out the same formula if it contains a date. Help?
Bookmarks