Thread: How do I make a formula read a result rather than a formula
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
VBA Noob
 
Posts: n/a
Default How do I make a formula read a result rather than a formula

Try using weekday instead of Monday

=IF(WEEKDAY(A23)=2,"CREW"," ")


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=553794

Reply With QuoteReply With Quote