Anyone know a formula for counting the number of cells that contain a specific text?
Here, I am trying to count the number of cells that contain today's date. I have a spreadsheet with a bunch of accounts that have a note next to each account. The note cell is dated as of a certain date...for example, the note cell may say something like "called and left a VM - 10/3/16"
How do I write a formula that counts the number of cells that contain today's date, or any date for that matter?
I keep trying to use the COUNTIF formula and I can't figure it out...please advise...thx!
Dominick
Bookmarks