Danny, did you even try Venkat's solution.
I tried it and it works like a charm, guess you would like to read it again:
Suppose you have 1/1/09 in cell A1,
Then use cell B1 to input this formula: =TEXT(A1,"mmm") .
If you want the full monthname instead of 3 letters add another m,
like this =TEXT(A1,"mmmm") .
Hope it's clear now.