Posted to microsoft.public.excel.misc

Vic09

external usenet poster

Posts: 1

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

Reply With Quote

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

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

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

All times are GMT +1. The time now is 07:12 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us