Hi everyone,

It seems to working now!
Thanks for your help.

Kind regards,
Peggy

"Niek Otten" wrote:

Hi Peggy,

This?

=IF(MOD(B2,1)TIME(14,0,0),TODAY()+1, TODAY())

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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