Hi Bob,
That's slightly reassuring. However, could mine not be working because I'm
still on excel 2000?

Thanks for your help.

Regards,
Peggy

"Bob Phillips" wrote:

Oops, you did actually say that didn't you?

It works okay for me Peggy, at the moment it is showing 30th Jan for me (it
is 11:12AM here)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Peggy" wrote in message
...
Hi Bob,
I have =Now() in B2 so it records the current date and time.

"Bob Phillips" wrote:

It all depends upon what is in B2. What is in there?


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"Peggy" wrote in message
...
Hi,

I've been working with the following formula:
IF(B2<time(14,0,0),today()+1, today()).

What the formula should do is determine if it is before 2pm on a given
day
then put today's day. If it's after 2pm then put tomorrow's date. I
have
formatted cell B2 to state =Now().

Unfortunately, it's not working and I always get tomorrow's date. Any
ideas
how I can fix this to make the formula extremely robust?

Many thanks,
Peggy