Hi all,
I'm importing a .xls file into my own file.
Basically I'm copying one sheet, and one of the columns has dates. The values are in general format (example: 1/14/2019 3:24:51 AM) and in US format.
I need to change the format to date (without the time) and to Europe format so I can make analysis based on date (month, year, etc). For example, turn 1/11/2019 1:02:27 PM to 11-01-2019
This is what I'm doing so far:
1st step: [IF(F2<>"";TEXT(F2;"mm/dd/aaaa");"")]
2nd step: = [IF(F2<>"";VALUE(SUBSTITUTE(V2;"/";"-"));"")]
But the formulas only seem to work with some cells I don't know why
I'm importing a .xls file into my own file.
Basically I'm copying one sheet, and one of the columns has dates. The values are in general format (example: 1/14/2019 3:24:51 AM) and in US format.
I need to change the format to date (without the time) and to Europe format so I can make analysis based on date (month, year, etc). For example, turn 1/11/2019 1:02:27 PM to 11-01-2019
This is what I'm doing so far:
1st step: [IF(F2<>"";TEXT(F2;"mm/dd/aaaa");"")]
2nd step: = [IF(F2<>"";VALUE(SUBSTITUTE(V2;"/";"-"));"")]
But the formulas only seem to work with some cells I don't know why
