With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Thursday, October 30, 2014
yogi_Convert Date in MM/DD/YYYY Style to DD/MM/YYYY Style
(https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!mydiscussions/docs/zSxgl70lFq8) Formula to change day, month, year order Hi Folks,
I currently have a list of dates: 10/23/2014 (month/day/year). I'd like to change it to be (day/month/year), is there a formula to do so? And I tried to edit the cell date format, but the date is a result from an existing formula, so it does not do anything.
Thanks Yogi, do you work for google? I see your answers here often, and they're quite good. The formula you offered "TEXT(<date>,"dd/mm/yyyy")" works but it does not switch the day and month. Is seems to simply convert the existing cell into text.
I'm using the older google sheets if that matters. The cell which I'd like to switch the date order on is polled by the following formula