Converting date values into text 1

[ADE6]

Hi

I am using the date formula below to give me the name of the months found in column M

This works ok apart from the times that there is no date to be found in certain cells in column M and they are blank cells,the formula then returns the result JANUARY.

When cells in column M are blank i would like the formula cell to remain blank and not return any text at all.


=UPPER(TEXT(M2,"MMMM"))


COL M------COL R
Date------MONTH

Jul-02----JULY
BLANK-----JANUARY

Required result
Jul-02----JULY
BLANK-----BLANK

Thanks for the help

Ade

 

[xlbo]

=if(M2="","",UPPER(TEXT(M2,"MMMM")))


Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question