I have a problem that is driving me nuts. In cell A1 I have a heading
of Time, and in B1 I have the heading Date. Column A2:A501 is
formatted in hh:mm and B2:B501 is formatted daddy - dd/mmm/yyyy.

I want to use a if statement to if the date in say row 3 and the time
in the same row has elapsed.

I can get the today to work by using =if(b4today(),"yes","no") but
this only gives me from midnight on the day in question, where I need
it from the date and time.

Thanks

Michael

"Michael" wrote:

I have a problem that is driving me nuts. In cell A1 I have a heading
of Time, and in B1 I have the heading Date. Column A2:A501 is
formatted in hh:mm and B2:B501 is formatted daddy - dd/mmm/yyyy.

I want to use a if statement to if the date in say row 3 and the time
in the same row has elapsed.

I can get the today to work by using =if(b4today(),"yes","no") but
this only gives me from midnight on the day in question, where I need
it from the date and time.

Thanks

Michael

Michael

Is this what you need?
=IF(B13+A13TODAY(),"yes","no")

regards
Peter

I think Peter means NOW(), and shouldn't elapsed be <?

=IF(B13+A13<NOW(),"yes","no")


--

HTH

RP
(remove nothere from the email address if mailing direct)


"PeterAtherton" wrote in message
...


"Michael" wrote:

I have a problem that is driving me nuts. In cell A1 I have a heading
of Time, and in B1 I have the heading Date. Column A2:A501 is
formatted in hh:mm and B2:B501 is formatted daddy - dd/mmm/yyyy.

I want to use a if statement to if the date in say row 3 and the time
in the same row has elapsed.

I can get the today to work by using =if(b4today(),"yes","no") but
this only gives me from midnight on the day in question, where I need
it from the date and time.

Thanks

Michael

Michael

Is this what you need?
=IF(B13+A13TODAY(),"yes","no")

regards
Peter

On Sun, 24 Apr 2005 14:19:04 -0700, "PeterAtherton"
wrote:

=IF(B13+A13TODAY(),"yes","no")

Hi Peter

I tried the above formula but it did not work properly the day was
fine but not the time. I altered your formula slightly TODAY() has
been substituted for NOW(). This now works me thats.

Michael