Thread: How do I make a formula read a result rather than a formula
View Single Post
  #6   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

Not sure what your criteria is so replaced with day of week

=IF(WEEKDAY(A23)=6,"Saturday",IF(WEEKDAY(A23)=7,"S unday",IF(WEEKDAY(A23)=1,"Monday",IF(WEEKDAY(A23)= 2,"Tuesday",IF(WEEKDAY(A23)=3,"Wednesday",IF(WEEKD AY(A23)=4,"Thursday",IF(WEEKDAY(A23)=5,"Friday","" )))))))


--
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