You don't show GetName, but I assume it is a simple function to return the
user name, and with such a function it worked fine for me.

I simplified it though like so

="Good
"&LOOKUP(MOD(NOW(),1),{0,0.5,0.75},{"Morning","Afe ternoon","Evening"})&GetNa
me(2)&"Today is"&" "&TEXT(TODAY(),"mmmm dd, yyyy")

The other thing to note is that it will not update as the time changes,
unless some othe calc happens.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"edwardpestian"
wrote in message
news:edwardpestian.29wgbb_1151140802.4986@excelfor um-nospam.com...

I have the following formula, which calls a function in order to get the
windows user name, and then offers them a greeting. What I'm trying to
do is take the user name and turn it into thier real name. I only have
about 5 people that use this workbook. So I'd like jdoe1 to be John Doe
1, and jdoe2 to be John Doe 2, etc. I can't seem to get it to work for
multiple persons.

=IF(NOW()-INT(NOW())<0.5,"Good Morning"&" "&GetName(2)&"Today is"&"
"&TEXT(TODAY(),"mmmm dd, yyyy"),IF(NOW()-INT(NOW())<0.75,"Good
Afternoon"&" "&GetName(2)&"Today is"&" "&TEXT(TODAY(),"mmmm dd,
yyyy"),"Good Evening"&" "&GetName(2)&"Today is"&" "&TEXT(TODAY(),"mmmm
dd, yyyy")))

Thanks in advance.

ep


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile:
http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=555196