Date Issue
 

Using following formula in Excel 03,
=IF(MONTH(H2)=1,"January",IF(MONTH(H2)=2,"February ",IF(MONTH(H2)=3,"March",IF(MONTH(H2)=4,"April",IF (MONTH(H2)=5,"May",IF(MONTH(H2)=6,"June",IF(MONTH( H2)=7,"July",0))))))),
however it doesn't work past July? Is this a limitation with Excel 03. I have
checked data format in relevant column etc. Any suggestions? Thanks

Date Issue
 

Try this:

=TEXT(H2,"mmmm")

Does that help?

Regards,

Ron Coderre
Microsoft MVP (Excel)

"Vic09" wrote in message
...
Using following formula in Excel 03,
=IF(MONTH(H2)=1,"January",IF(MONTH(H2)=2,"February ",IF(MONTH(H2)=3,"March",IF(MONTH(H2)=4,"April",IF (MONTH(H2)=5,"May",IF(MONTH(H2)=6,"June",IF(MONTH( H2)=7,"July",0))))))),
however it doesn't work past July? Is this a limitation with Excel 03. I
have
checked data format in relevant column etc. Any suggestions? Thanks

Date Issue
 

Excel 2003 has a 7 nested IF limit.

See Ron's suggestion for a much shorter formula.


Gord Dibben MS Excel MVP

On Thu, 19 Mar 2009 03:16:01 -0700, Vic09
wrote:

Using following formula in Excel 03,
=IF(MONTH(H2)=1,"January",IF(MONTH(H2)=2,"Februar y",IF(MONTH(H2)=3,"March",IF(MONTH(H2)=4,"April",I F(MONTH(H2)=5,"May",IF(MONTH(H2)=6,"June",IF(MONTH (H2)=7,"July",0))))))),
however it doesn't work past July? Is this a limitation with Excel 03. I have
checked data format in relevant column etc. Any suggestions? Thanks