How I can get monthname from the following formula
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
|