|Well, your answer is sort of correct. |
It's obvious that you did not copy that formula directly from a worksheet because, as written, it probably won't work. In fact, I tried it on 2 different machines and it doesn't work.
Take a look at the double quotes after n74. They appear to be a different font or style than the rest of the quotes and Excel does not recognize them. When pasted into Excel, they end up looking exactly like the other quotes, but they aren't the same.
It took a little work to determine why Excel was throwing up an error, but it turned out to be those quotes.
In addition, while it won't impact the results you'll get (once the quotes are fixed) you have an extra set of parenthesis in your formula.
You don't need "double parenthesis" around the INDIRECT function.
The final version that I would use is this:
=COUNTIF(INDIRECT("'" & TEXT(TODAY(),"mm-dd") & "'!N67:N74"),"*m*")
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.