Thread
:
Formula to ask what Time/Date it is.
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Formula to ask what Time/Date it is.
Have you looked in the help index for TIME.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Peggy" wrote in message
...
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett