Thread: How I can get monthname from the following formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default How I can get monthname from the following formula
=TEXT(DATE(0,A1,1),"mmmm") if the formula you gave is in A1.
Or just put your formula in place of A1 in the above equation.
--
David Biddulph

"pol" wrote in message
...
Please let me know to get month name from the following equation

myFormula = _
"=Month(IF(LEFT(CELL(""format"",RC[1]),1)=""D"",RC[1],DATE(LEFT(RC[1],4),MID(RC[1],5,2),RIGHT(RC[1],2))))"

With thanks

Pol




Reply With QuoteReply With Quote