="Good"&
"&LOOKUP(MOD(NOW(),1),{0,0.5,0.75},{"Morning","Aft ernoon","Evening"})&
"&IF(GetName(2)="jdoe1","John Doe 1"&" "&"Today is"&
"&TEXT(TODAY(),"mmmm dd, yyyy"),IF(GetName(2)="jdoe2","John Doe 2"&
"&"Today is"&" "&TEXT(TODAY(),"mmmm dd
yyyy"),IF(GetName(2)="jdoe3","John Doe 3"&" "&"Today is"&
"&TEXT(TODAY(),"mmmm dd, yyyy"),"Today is"&" "&TEXT(TODAY(),"mmmm dd
yyyy"))))

Is there a better way so that I could add more that 7 users and not b
limited to 7 nested IF statements.

Thanks.

e

--
edwardpestia
-----------------------------------------------------------------------
edwardpestian's Profile: http://www.excelforum.com/member.php...fo&userid=3380
View this thread: http://www.excelforum.com/showthread.php?threadid=55519