how to get monthname
If you must use your formula, then:
=CHOOSE(MONTH(IF(LEFT(CELL("format",A3),1)="D",A3, DATE(LEFT(A3,4),MID(A3,5,2),RIGHT(A3,2)))),"jan"," feb","mar","apr","may","jul","aug","sep","oct","no v","dec")
but easier is:
=IF(LEFT(CELL("format",A3),1)="D",A3,DATE(LEFT(A3, 4),MID(A3,5,2),RIGHT(A3,2)))
and format the cell with the formula as Custom "mmmm"
--
Gary''s Student - gsnu200855
"pol" wrote:
Hi all,
please let me know From the following formula how to derive monthname
=MONTH(IF(LEFT(CELL("format",A3),1)="D",A3,DATE(LE FT(A3,4),MID(A3,5,2),RIGHT(A3,2))))
with thanks and regards
Pol
|