I have a date time value in a cell

It appears in cell as "1/1/04 18:00

In formula bar it appears as " 1/1/2004 6:00:55 PM

I need to do calcs on this in excel - if date is = " another date I try
toi enter" then good, bad

not having any luck

thanks for your time.