Month and Year

  • Thread starter Thread starter Dushyant Rajput
  • Start date Start date
D

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
 
Dushyant Rajput said:
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
Click to expand...

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.
 
B1: =TEXT(A1,"mmm")
C1: =TEXT(A1,"yyyyy")

--

HTH

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