Forum Discussion
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
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
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.