Month and Year

[Dushyant Rajput]

Hi,

I have a date mm/dd/yyyy in a excel spreadsheet , I need to extract month
and Year in different column .

Like in A1 = date (mm/dd/yyyy) B1 = mmm C1 = yyyy

Hope its understand.

Thnx
Dushyant

 

[Anne Troy]

Easiest method: Just type =A1 and format the cell to show just the month or
just the year.
*******************
~Anne Troy

www.OfficeArticles.com

 

[Jef Gorbach]

Hi,

I have a date mm/dd/yyyy in a excel spreadsheet , I need to extract month
and Year in different column .

Like in A1 = date (mm/dd/yyyy) B1 = mmm C1 = yyyy

Hope its understand.

Thnx
Dushyant

If date column is TEXT and all cells follow the mm/dd/yyyy format then you
could do either
B# = left(trim(A#),2) and C#=right(trim(A1),4)
or
use Data\Text to Columns, splitting on "/" to three unused columns
elsewhere then move Month to B# and Year to C#.

However if the date column is NUMERIC/DATE then I believe B#=month(A#) and
C#=Year(A#) will do the trick.

 

[Bob Phillips]

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

B1: =TEXT(A1,"mmm")
C1: =TEXT(A1,"yyyyy")

--

HTH

RP
(remove nothere from the email address if mailing direct)