Getting an incorrect result when combining text() and month()

[ndrobinson]

Howdy,

I'm trying to extract the full month name from cells that are in a "d"-"mmm" format by using the text() formula. The full formula I'm using is

Please Login or Register  to view this content.

But it always returns "January" regardless of the actual date. Any idea what I'm doing wrong?

[Pete_UK]

If E2 contains a date that is formatted to look like d-mmmm, then you can do this:

=TEXT($E2,"mmmm")

If it is a text value, then you can do this:

=RIGHT($E2,LEN($E2)-FIND("-",$E2))

Hope this helps.

Pete

[ndrobinson]

Ah, first one definitely works. Much appreciated.