Thread: Big problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ana ana is offline
external usenet poster
 
Posts: 3
Default Big problem

Hi everybody!

My problem is : I get data from internet in a sheet, I
have to do it every day. I have in cell A1 the following
sentence :

Daily Returns for Major Fixed Income Indexes for May 21
2004 in EURO Terms

and I need the date , every day there will be a diferent
date ; My problem is to obtain from that text the exact
date in a date format .. How can I do it ?
I have tried to use formules like right and left , but as
is a variable text , I do not get always the excact date
and of course it is not in a date format .

anyone have any idea ??
Thanks a lot
Ana