thanks I got it to work as well but not in the if box - just straight in the
cell

"Gary''s Student" wrote:

Make sure your IF() is O.K.

Example
A1 is 9/22/2005 13:18
B1 is 9/22/2005 19:20
C1 has =IF(B1=A1,1,2)
and returns 1
--
Gary''s Student


"Todd F." wrote:

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.