problem about working with dates.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

simon steel - 15 Jan 2008 22:29 GMT

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

Reply to this Message

Nick Hodge - 15 Jan 2008 22:37 GMT

Simon

If the dates in column A are truly dates just format the new column as mm-yy
should suffice

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
web: www.nickhodge.co.uk
web: www.excelusergroup.org

> Column 1 contains a list of dates in format DD/MM/YYYY
>
[quoted text clipped - 9 lines]
>
> ss

Reply to this Message

Gord Dibben - 15 Jan 2008 23:30 GMT

In other column enter =cellreffromdatecolumn

Format as MM-YY

Gord Dibben MS Excel MVP

>Column 1 contains a list of dates in format DD/MM/YYYY
>
[quoted text clipped - 9 lines]
>
>ss

Reply to this Message

kaliman - 18 Jan 2008 21:34 GMT

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

> Column 1 contains a list of dates in format DD/MM/YYYY
>
[quoted text clipped - 9 lines]
>
> ss

Reply to this Message