You can enter a formula like this in a column next to your two
columns:

=IF(A1=B1,"same","Different")

and copy down. You can then investigate the "Different" cells more
thoroughly, maybe by means of a filter.

Hope this helps.

Pete

On Aug 1, 6:22 pm, newyorkjoy
wrote:
Hello again. How do I compare data in two columns?

Both columns contain dates. Both columns should be identitcal,, but if
they are not, I need excel to highight, or to otherwise let me know which
dates are not identical in both columns.

newyorkjoy
thanks for the help!