Aug 14 2021 09:33 AM
I often select data from my bank-account and they use the date-format dd.mm.yyyy but to use dates to manage my data, I use the format dd-mm-yyyy. How to convert to this format in an easy way ?
I have used the search/change facility to convert all . to -, but it isn't a nice way. Can you help.
Aug 14 2021 09:47 AM
Solution
Here's a formula that will convert your bank's dates (assuming they're in there as text) to a standard Excel formatted datevalue
=DATE(VALUE(RIGHT(A1,4)),VALUE(LEFT(A1,2)),(VALUE(MID(A1,4,2))))
Aug 14 2021 03:34 PM
The Danish formulas have another structur with ; instead of , and the form had to be with rigth, mid and lest in the end before it worked. @ean-1501
Aug 14 2021 09:47 AM
Solution
Here's a formula that will convert your bank's dates (assuming they're in there as text) to a standard Excel formatted datevalue
=DATE(VALUE(RIGHT(A1,4)),VALUE(LEFT(A1,2)),(VALUE(MID(A1,4,2))))