Date convert into manth name

Closed
danny - 30 Jul 2009 à 23:30
 danny - 31 Jul 2009 à 06:11
Hello,
my request is, i am maintainning a birth day record of around 150 employees in axcel sheet .
their date of birth has been mentioned as numeric date,so its very difficult to find the particular
month birth day list.

my request is , is there any formula in excel where we can type numeric date ,month ,year and we get the month name ?

for example if i am typing 01-Jan-2009 can we get the month name ?

please help

thanx
danny

2 responses

venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
31 Jul 2009 à 06:06
suppose following entered in A1
1/1/09
and formatted as
1-Jan-09

then in B1 copy paste this formula
=TEXT(A1,"mmm")
you will get
jan

try it for a few examples of dates.
thanks a lot venkat