Does Not Equal Another Cell

[SuperSquirrel]

I want to compose a COUNTIF statement where I'm counting how many things are NOT equal to a certain cell

Example

A1 = 12/1/17

=COUNTIFS(Table1101[Previously],NOT(A1))

I know I can do =COUNTIFS(Table1101[Previously],"<>43070") and it'll work, but I want the date to change

it doesn't work. Any other idea?

 

[dreid1011]

Perhaps this:

=COUNTIFS(Table1101[Previously],"<>"&A1)

 

[SuperSquirrel]

Perhaps this:

=COUNTIFS(Table1101[Previously],"<>"&A1)

genius!

 

[dreid1011]

genius!

You're welcome.