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, December 6, 2012
yogi_Manipulate Dates To And Fro Some Different Formats
Google Spreadsheet Post #917
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MIwww.energyefficientbuild.com. Dec 7, 2012 user will37 said:(http://productforums.google.com/forum/?zx=ylk4koc91986#!category-topic/docs/spreadsheets/4obSpPXMN_g) Trouble converting dates to a format that can be manipulated. I'm importing a CSV file where the dates are shown like "2012-07-01 01:45:14 UTC". I have truncated the date to 2012-07-01 using =left(G7,10), but when I try to use the date in a math formula (G9+1), I get this back:41092. In other spreadsheets I have created in Google spreadsheet the date autocorrects (or something) from 2012-07-01 to 7/1/2012. I can manipulate that date. But in the spreadsheet based on an imported .csv file the autocorrect doesn't happen and I cannot manipulate the date.
I have selected a cell with a date and used the 123 button to try to format the cell as any number of date formats but nothing changes. Does anyone know if there is a function that will convert a date like 2012-07-01 to 7/1/2012? Should I have found a better way to convert the date from 2012-07-01 01:45:14 UTC to 7/1/2012?