Forum Discussion

ean-1501's avatar
ean-1501
Copper Contributor
Aug 14, 2021
Solved

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's avatar
    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))))

     

     

ean-1501's avatar
ean-1501
Copper Contributor
Aug 14, 2021
It works - super
ean-1501's avatar
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