How do I count an occurrence when two dates don't match?

BFuller

Hello,

Can someone help me create a formula that will look at the form created date (date only) and compare it to the activity date being reported and tell me how frequently the activity date is not the same as the created date?

I get invalid operation with the following:

=COUNTIFS({NS FSE}, [FSE Name]@row, {NS entry date} <> {NS Activity Date})

Wondering also how I can use date only since the created date includes time stamp. Right now I created a separate column to remove the time stamp, but it would be awesome if I didn't have to do that.

Many thanks in advance!

Hollie Green

You are missing a comma. Formula should look like this

=COUNTIFS({NS FSE}, [FSE Name]@row, {NS entry date}, <> {NS Activity Date})

Hollie Green

You should also be able to use DATEONLY({created date}) in the place of your helper column name

BFuller

@Hollie Green thank you!

Leibel S

@BFuller

add a column in your source sheet that checks if the date matches. Then use that column in your COUNTIFS.