Date convert into manth name

Closed
danny - Jul 30, 2009 at 11:30 PM
 danny - Jul 31, 2009 at 06:11 AM
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 replies

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Jul 31, 2009 at 06:06 AM
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.
3
thanks a lot venkat
0