Forum Discussion
Chubby1983
Dec 02, 2019Copper Contributor
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/yyy...
alandorss
Dec 02, 2019Brass Contributor
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")