Calculations with date time interval

[Guest]

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.

 

[Bob Phillips]

=IF(INT(that_date)>=another_date,"good","bad")

 

[Guest]

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

 

[Ron Rosenfeld]

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.

Assume your date is in A1 and the date you are comparing it to is in A2 and is
just a date (i.e. -- no time portion).

=IF(INT(A1)>A2,"good","bad")


--ron

 

[Guest]

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

 

[Guest]

thanks now I am going to try an nested if

=IF(INT(that_date)>=another_date,"good","bad")

 

[Guest]

thanks

Assume your date is in A1 and the date you are comparing it to is in A2 and is
just a date (i.e. -- no time portion).

=IF(INT(A1)>A2,"good","bad")


--ron