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.
Wednesday, May 9, 2012
yogi_Sort Data in Column A By Year Of Date In Column B In Ascending Order By Date
user mjw2185 said: Format date to display year onl
I have a spreadsheet compiled with production information on various films. I want to be able to enter a film's release date as a full date, such 5/9/12, but have it only display as "2012" in the cell.
Currently I am entering only the year of a release date, but I am then not able to sort the releases in chronological order if there are multiple titles in the same year. If possible, I'd like to display the year only in the cell, but have the full date taken into account when sorting.