Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

=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

Check out our Excel Resources

Re: =month? I need help!

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

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

good luck

Oops

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

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"))

Thanks supper fast response <4 minutes

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.