wildturkey
Board Regular
- Joined
- Feb 21, 2006
- Messages
- 189
- Office Version
- 365
- Platform
- Windows
Not sure where to start on this
I have an external data source in excel with a list of dates, I do not believe that these dates are being recognised as dates and have used =DATE(RIGHT(B968,4),MID(B968,4,2),LEFT(B968,2)) on the cells which appear as 30/06/2019 and this gives me what I'm hoping is a list of dates in my new column A.
When I sort column A everything looks fine until half way down the list when I start getting dates such as
12/09/3473, 13/10/3474 etc and these are pointing at cells that read 03/01/2019 and 04/01/2019 respectively. If I format as numbers the original cells I get 43468 and 43469 which seams to suggest that they are indeed dates, and if I format the new dates in column A I get 574783 and 575179.
On the initial part of the dates list, if I format the original dates as numbers nothing changes, but I do get 43480 or similar if I format as numbers the new dates in column A.
My problem though is definitely the second hald where =DATE(RIGHT(B968,4),MID(B968,4,2),LEFT(B968,2)) is failing, despite the appearance of the values in column B all appearing as dates...
Many thanks
I have an external data source in excel with a list of dates, I do not believe that these dates are being recognised as dates and have used =DATE(RIGHT(B968,4),MID(B968,4,2),LEFT(B968,2)) on the cells which appear as 30/06/2019 and this gives me what I'm hoping is a list of dates in my new column A.
When I sort column A everything looks fine until half way down the list when I start getting dates such as
12/09/3473, 13/10/3474 etc and these are pointing at cells that read 03/01/2019 and 04/01/2019 respectively. If I format as numbers the original cells I get 43468 and 43469 which seams to suggest that they are indeed dates, and if I format the new dates in column A I get 574783 and 575179.
On the initial part of the dates list, if I format the original dates as numbers nothing changes, but I do get 43480 or similar if I format as numbers the new dates in column A.
My problem though is definitely the second hald where =DATE(RIGHT(B968,4),MID(B968,4,2),LEFT(B968,2)) is failing, despite the appearance of the values in column B all appearing as dates...
Many thanks