Thanks . But it is not working when I am applying. Syntax error

"Niek Otten" wrote:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"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