Calculations with date time interval

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.

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

--
HTH

Bob Phillips

"Todd F." <[email protected]> wrote in message
news:[email protected]...
> 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.

thanks now I am going to try an nested if

"Bob Phillips" wrote:

> =IF(INT(that_date)>=another_date,"good","bad")
>
> --
> HTH
>
> Bob Phillips
>
> "Todd F." <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>

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.

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.

On Thu, 22 Sep 2005 09:56:02 -0700, "Todd F." <[email protected]>
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.

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

thanks

"Ron Rosenfeld" wrote:

> On Thu, 22 Sep 2005 09:56:02 -0700, "Todd F." <[email protected]>
> 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.
>
> 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
>