Forum Discussion
Issue with dates in .csv file
Hi all, I need some help with a date issue I'm having in a .csv file.
The data is extracted from a new system I'm using in my company, and when it extracts the dates some of them are in mm/dd/yyyy hh:mm and some are in dd/mm/yyyy.
What I'm trying to do is 'normalise' these dates so I can see how many days they have been in the system queue for. So, for example, if I have an item where the date is 11/14/2019 01:49PM and, i need some way to show that it's been in the queue for 19 days.
Can anyone give me any advice on how to do this?
Thanks!
1 Reply
Chubby1983 Haha, this is literally the exact same problem another user had last week. Take a look at the suggestions to format here: https://techcommunity.microsoft.com/t5/Excel/Import-txt-VBA-macro-changing-date-format-in-random-cells/m-p/1036987
On the other hand, it seems you have another problem. the date value is simply a number, so you could add in a column and type
=IF((now()-A1)>19,"Greater than 19 Days","Less than 19 days ago")
