Countifs exclude today's date

[DPD011]

Hello,

Im trying to create a countifs formula which looks at a cell which includes a letter and month/day, for example A10/31, on my countifs formula Im trying to exclude all entries that have today day. For example, today=10/31/2018, any cell which include 10/31 should be excluded from my countifs. Thank you

 

[Bo_Ry]

Please try

=COUNTIF(A1:A10,"<>"&TODAY())

 

[James006]

Hello,

Why don't you post your current formula ... since you want it to be amended ...

 

[Aladin Akyurek]

Try...

=COUNTIFS(LetterDateRange,"?*")-COUNTIFS(LetterDateRange,"*"&TEXT(TODAY(),"mm/dd"))