problem about working with dates.

  • Thread starter Thread starter simon steel
  • Start date Start date
S

simon steel

Column 1 contains a list of dates in format DD/MM/YYYY

I want to manipulate this data such that another column shows MM-YY
based on data in column 1. The change from slashes to hyphen separation is
required.

How can I do this?

[Does not need to be done in one step. I tried using the =right(_, _)
command to seperate the '08' off with the intent of concatenating the
seperated stuff back together- but this did not work.]

ss
 
In other column enter =cellreffromdatecolumn

Format as MM-YY


Gord Dibben MS Excel MVP
 
Another way (considering that you mentioned you wanted to work in another
column):

say your first date is in A1, In column 2 write:
=month(A1)&"-"&right(year(a1);2))

HTH
 
Back
Top