how to get monthname
With your formula..
=TEXT(IF(LEFT(CELL("format",A3),1)="D",A3,DATE(LEF T(A3,4),MID(A3,5,2),RIGHT(A3,2))),"mmm")
If this post helps click Yes
---------------
Jacob Skaria
"Jacob Skaria" wrote:
If A3 is in date format the below formula will return the month name..Does
that help..If not post back
=TEXT(A3,"mmm")
If this post helps click Yes
---------------
Jacob Skaria
"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
|