title: How to swap date and month digits in excel
body: <p>I have a date format of mm-dd-yyyy (03-12-2018). Excel reads it as 3rd December 2018. The actual date is 3rd March 2018, I want to convert it into 12th March 2018 in dd-mm-yyyy format.</p>
  
  <p>Let's assume our data is in cell B2 and it reads 03-12-2018 i.e 3rd December 2018 I have tried =Date(right(B2,4),mid(B2,4,2),left(B2,2)). It gives 12-02-3440 as output due to excel date-time code.</p>