Extract month from a date in Excel Solved

Question

Hello,

I would like to know which formula I should use to achieve the following:

I have dates in one column:
A
01/01/2001
03/05/2002
09/11/2003
etc..

and I would like to display in the following columns:
B
January
May
November
...

C
2001
2002
2003
...

Thank you in advance for your advice because I have 1300 rows and I don't see myself typing everything by hand ;)

eric1708 · Accepted Answer

If the date is in A1, then:  =CHOOSE(MONTH(A1);"January";"February";"March";"April";"May";"June";"July";"August";"September";"October";"November";"December")

chrij · Answer

The simplest way is to copy the date and ask to display only the month (Format -> Cell, in custom formats put "mmmm").

Margaux · Answer

=YEAR(A1) gives me 1905 for 01/01/2008...  But it's not a big deal, my data is sorted chronologically, so I can fill this in manually.

Nelisa2669 · Answer

Hello
Otherwise, with data conversion (you copy the column where the date is to another column, leaving empty columns to the right, then fixed-width data conversion), it works quite well too.
And if you want the names of the months instead of the numbers, you can do it with an IF function: IF(A1=1;"January";IF(A1=2;"February"...).

Toppsy · Answer

Hello Use the TEXT function and the format to convert the date in the cell to month. Cell A1 contains the date, the formula = TEXT(A1; "mmmm")  will give the expected result.

Extract month from a date in Excel

5 réponses

Canon mb5350 - cartridge replacement impossible

Texture issues in enshrouded

Football manager (club management game)

Select next line csh foreach

Win32 kamso then rootkit detection

Win32:spyware-gen [trj] detected by avast

Unknown video error on the freebox player

Make it or break it

How to open a cbr file

Please log in with manager privileges.