convert to another date-format

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 hav...

excel

mathetes
Aug 14, 2021
ean-1501

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))))

mathetes

Gold Contributor

Aug 14, 2021

ean-1501

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))))

ean-1501

Copper Contributor

Aug 14, 2021

It works - super

ean-1501
Copper Contributor
Aug 14, 2021
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

Forum Discussion

convert to another date-format