=month? I need help!

Posted by Paul on October 02, 2001 2:36 PM

I have a 10-2-2001 in A1, I am using=month(a1) in cell b1, this returns 10. I want it to return October I have tried formatting the cell as"MMMM" but it returns January. What do I need to use? Also if a1 is blank I would like for B1 to show nothing. Thanks

Posted by IML on October 02, 2001 2:40 PM

Change your formual in B1 to =A1 and apply the MMMM format.

good luck

Posted by IML on October 02, 2001 2:43 PM

Oops

For the blank part, you could use the following formula. No cell formatting should be necessary. This will return the month only if A1 is a valid date format
=IF(ISBLANK(A1),"",TEXT(A1,"MMMM"))

Posted by Paul on October 02, 2001 2:49 PM

Thanks supper fast response <4 minutes