| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MONTHNAME when getting external data from Access | Excel Worksheet Functions | |||
Linear Mode
