Forum Discussion

Cass_M's avatar
Cass_M
Copper Contributor
Jul 24, 2023

Converting dates to date format

My current date is Mon, 07 Aug 2023

 

I would like to only have DD, MM, YY so that I can import dates into Outlook Calander.

 

Is anyone able to assist please?

 

Much appreciated

excel
Formulas and Functions

4 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jul 24, 2023

    Cass_M 

    If you value is actual date formatted as "ddd, dd mmm yyyy" when it's nothing to do.

    If the value is text which is looks like date, you may convert them to dates with formula like

    =DATE( RIGHT(A1, 4), MONTH(1&MID(A1, 9, 3) ), MID(A1, 6, 2))

    Applied format doesn't matter.

    • Cass_M's avatar
      Cass_M
      Copper Contributor
      Jul 28, 2023

      SergeiBaklan thank you very much.

       

      this formula has taken off the day text however I would like it to be DD MM YY. Are you able to assist me in getting the date in this format?

       

      Thankyou

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Jul 28, 2023

        Cass_M 

        In addition to HansVogelaar , you may apply any format you wish staying on the cell, Ctrl+1 and here select the format or apply custom one. Here are variant for the same date

        Outlook also shall not care which format you use, if only that's Excel file (not csv) and within it you have dates, not texts which looks like dates.

Resources