SOLVED

convert to another date-format

Copper Contributor

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.

 

3 Replies
best response confirmed by ean-1501 (Copper Contributor)
Solution

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

 

 

It works - super

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 

1 best response

Accepted Solutions
best response confirmed by ean-1501 (Copper Contributor)
Solution

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

 

 

View solution in original post