TEXT & MONTH Formulas returning wrong Month

Should be simple, I believe the problem is with the TEXT function. I'm trying to return the name of the Month associated with a Date in a separate cell. Problem is, regardless of the date my formula returns 'January"

Here's the formula '=TEXT((MONTH(D823)),"mmmm")'

Cell D823 contains my date '10/4/10' - It's in date format (serial number 40455 if it was in general)

Error checker says the MONTH fnctn returns '10' as the month, but TEXT returns January, not October. Tried it on different dates, same result.

Any ideas?

Thanks!

You don't need the MONTH function after your TEXT.

=TEXT(D823,"mmmm")

What you're doing is first changing the date into the month number (10) and then evaluated that as a date which is the 10th of January 1900 and formatting that as mmmm.

Does that help?