Hi,

Do you have any ideas what formula I could put together to set up the
following criteria:

Purpose: to determine what time/date a cell is populated with.

Action: If the date & time are < 14:00 then put today's date, if it's after
2pm then put tomorrow's date. I tried writing one:
=IF(D4<14:00,today(),today()+1) but for some reason excel didn't like what I
wrote.

I'm keen to put this formula into a macro so no one can alter the formula.
I'm happy doing that, it's just IF statements always trip me up!

Thanks for your help.
Peggy