how to get monthname

[pol]

Hi all,

please let me know From the following formula how to derive monthname

=MONTH(IF(LEFT(CELL("format",A3),1)="D",A3,DATE(LEFT(A3,4),MID(A3,5,2),RIGHT(A3,2))))

with thanks and regards

Pol

 

[Jacob Skaria]

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]

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

 

[Gary''s Student]

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","nov","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]

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","nov","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"

 

[Jacob Skaria]

With your formula..

=TEXT(IF(LEFT(CELL("format",A3),1)="D",A3,DATE(LEFT(A3,4),MID(A3,5,2),RIGHT(A3,2))),"mmm")

If this post helps click Yes

 

[Jacob Skaria]

With your formula..

=TEXT(IF(LEFT(CELL("format",A3),1)="D",A3,DATE(LEFT(A3,4),MID(A3,5,2),RIGHT(A3,2))),"mmm")

If this post helps click Yes

 

[Gary''s Student]

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]

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

 

[Dana DeLouis]

=IF(LEFT(CELL("format",A3),1)="D",A3,DATE(LEFT(A3,4),MID(A3,5,2),RIGHT(A3,2)))

Just a thought might be to ignore the Year and Day.

=IF(LEFT(CELL("format",A3),1)="D",A3,DATE(2000,MID(A3,5,2),1))

= = =
Dana DeLouis

 

[Dana DeLouis]

=IF(LEFT(CELL("format",A3),1)="D",A3,DATE(LEFT(A3,4),MID(A3,5,2),RIGHT(A3,2)))

Just a thought might be to ignore the Year and Day.

=IF(LEFT(CELL("format",A3),1)="D",A3,DATE(2000,MID(A3,5,2),1))

= = =
Dana DeLouis