Thread: how to get monthname
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pol pol is offline
external usenet poster
  
Posts: 129
Default how to get monthname
Hi all,

please let me know From the following formula how to derive monthname

=MONTH(IF(LEFT(CELL("format",A3),1)="D",A3,DATE(LE FT(A3,4),MID(A3,5,2),RIGHT(A3,2))))

with thanks and regards

Pol
Reply With QuoteReply With Quote