months from dobs

[Bodster]

I have a long list of details with one column listing the dates of birth in
the UK format. For example someone born on May 25th 1988 would be recorded
as 25/05/88. I want to add another column with the birth month being
recorded as May (or 05). How do I turn '25/05/88' into 'May'?

Cheers,

Bodster.

 

[Ardus Petus]

=TEXT(A1,"mmmm")

HTH

 

[Ragdyer]

With date in A1,
In B1 enter
=A1
And custom format B1 to either:
mmmm
OR
mm
OR
m