V
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
=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