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