How to find month in Date with excel formula.

[prince]

Sir, Will you please help me how can i find the birth month in Date of birth .
Like 10/01/2004 January
..... 1/04/1999 April

please suggest me the formula to solve this problem.

Regards,
Prince

[HansV]

Enter the following formula in H2:

=TEXT(G2,"mmmm")

and fill or copy down.

[prince]

Mr. HansV this format not working properly on the above attached file.
Date format in file is DD/MM/YYYY instead of MM/DD/yyyy.

[HansV]

Your date column has a mixture of formats: some cells are formatted as dd/mm'yyyy, others as mm-dd-yy:

S0953.png

[prince]

Mr. HanV thanks a lot for guided me.