Nick_London
05-19-2009, 04:47 AM
Hi,
I have the following date appearing in b3 of my sheet which comes from a web query: 01/05/2009
However this date is incorrect and should actually be 09/05/2009. The actual date on the web page appears as 09 May - i.e it has no year specified hence this probably explains why the date is appearing how it is.
I'm using the date function below to reconstruct the data into what it should be but it returns 03-Nov-2011.
The date function syntax is:
=DATE(2009,MID(B3,4,2),RIGHT(B3,2))
Can anyone suggest if there's another way of getting what I need?
Thanks,
Nick
I have the following date appearing in b3 of my sheet which comes from a web query: 01/05/2009
However this date is incorrect and should actually be 09/05/2009. The actual date on the web page appears as 09 May - i.e it has no year specified hence this probably explains why the date is appearing how it is.
I'm using the date function below to reconstruct the data into what it should be but it returns 03-Nov-2011.
The date function syntax is:
=DATE(2009,MID(B3,4,2),RIGHT(B3,2))
Can anyone suggest if there's another way of getting what I need?
Thanks,
Nick