Forum Discussion
Cass_M
Jul 24, 2023Copper Contributor
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
Cass_M
Jul 28, 2023Copper Contributor
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
HansVogelaar
Jul 28, 2023MVP
Apply the custom number format dd mm yy to the cell(s) with the formula.