One thing to remember, unless I am mistaken the time from the NOW function
will only be updated in a cell when a recalculation is done. Will this
affect the formulas that a NOW is part of?
(As in if you just use a NOW formula it will list a time and date, that time
and date will remain as is unless you recalc to match with time passing on
your clock.)
"edwardpestian" wrote:
I have the following function. I'm trying to say that if it is before
12:00 pm, say "Good Morning," if after 12:00 pm but before 6:00 pm say
"Good Afternoon," and otherwise say "Good Evening". The function
however, is not working properly. Any ideas?
=IF(NOW()<TODAY()+HOUR(0.5),"Good Morning"&" "&"Today is"&"
"&TEXT(TODAY(),"mmmm dd, yyyy"),IF(NOW()<TODAY()+HOUR(0.75),"Good
Afternoon"&" "&"Today is"&" "&TEXT(TODAY(),"mmmm dd, yyyy"),"Good
Evening"&" "&"Today is"&" "&TEXT(TODAY(),"mmmm dd, yyyy")))
Any ideas?
Thanks.
ep
--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=555043