The Poster's formula is quite interesting. It never occured to me to test
for "fake" dates by using the CELL() function.
--
Gary''s Student - gsnu200855


"Jacob Skaria" wrote:

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