Extracting dates from Data

**skate1991** · 07-30-2012, 04:14 AM

HI,

I was just wondering if there was a way to extract the date from my attached data,

Thanks

**Fotis1991** · 07-30-2012, 04:26 AM

Hi

If your data,always are like your sample, then in B1 and copy down.

=RIGHT(A1,11)

**benishiryo** · 07-30-2012, 04:34 AM

hi skate1991, if you just want it as text:
=RIGHT(A1,11)

if you do need it as an Excel-recognised date, try:
=DATEVALUE(RIGHT(A1,11))

then format the cells as you desire

**skate1991** · 07-30-2012, 04:40 AM

Thanks Works a treat

**Cutter** · 07-30-2012, 08:46 AM

@ skate1991

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.