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