convert date in TEXT into year

**Exxcel Noob** · 08-15-2012, 11:18 PM

hello everyone, is there a way to convert the data below into 'year' only?

to be honest all my data is in text format, so i'm stuck.

example:

A1: Monday 01/09/12 = B1:2012

Monday 01/09/12
Saturday 11/26/11
Saturday 11/19/11
Saturday 11/12/11
Saturday 11/05/11
Saturday 10/22/11
Saturday 10/15/11
Saturday 10/08/11
Saturday 10/01/11
Saturday 09/24/11
Saturday 09/17/11
Saturday 09/10/11
Saturday 09/03/11
Saturday 01/01/11
Friday 11/26/10
Thursday 11/18/10
Saturday 11/13/10
Saturday 11/06/10
Saturday 10/23/10
Saturday 10/16/10

---------- Post added at 10:18 PM ---------- Previous post was at 10:12 PM ----------

wait sorry, i want to convert it to regular date

for example:

monday 01/09/12 = 01/09/12

**vandan_tanna** · 08-15-2012, 11:30 PM

something like:

=DATEVALUE(RIGHT(A1,8))

result formatted as date

**vlady** · 08-15-2012, 11:33 PM

with regards to vandan
you can add a trim function in case you have spaces on the text dates.

=DATEVALUE(RIGHT(TRIM(A7),8))

thanks.

**Exxcel Noob** · 08-15-2012, 11:37 PM

ok but it doesn't work for this data

Saturday 10/22/11
Saturday 10/15/11
Saturday 10/08/11
Saturday 10/01/11

also, do you know something like this?

A1: Monday 01/09/12 = B1:2012

---------- Post added at 10:35 PM ---------- Previous post was at 10:34 PM ----------

hey vlady that work great :D

---------- Post added at 10:37 PM ---------- Previous post was at 10:35 PM ----------

wait never mind, i think i can use =DATEVALUE(RIGHT(TRIM(A7),8))

thanks guy!