Formula to ask what Time/Date it is.
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
|