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 |
How I can get monthname from the following formula
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 |
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 |
How I can get monthname from the following formula
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 |
How I can get monthname from the following formula
thaks a lot
I applied ur formula in my macro I hope now it is working "David Biddulph" wrote: =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 |
All times are GMT +1. The time now is 01:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com