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 have used the search/change facility to convert all . to -, but it isn't a nice way. Can you help.

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

3 Replies

mathetes
Silver 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

3 Replies

Resources