About Us

Vic09

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

Ron Coderre[_3_]

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

Gord Dibben

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date issue	Patrick C. Simonds	Excel Worksheet Functions	6	January 7th 09 08:00 PM
Date Issue	Clois Beckwith	Excel Discussion (Misc queries)	4	November 1st 07 03:55 PM
DATE ISSUE!	Joan	Excel Worksheet Functions	2	June 15th 06 03:39 PM
Date issue	polk383	Excel Worksheet Functions	3	June 10th 06 06:21 PM
Another Date issue.	TimM	Excel Worksheet Functions	1	November 17th 05 01:58 AM

Menu

About Us