Friday, September 28, 2012

yogi_Make A Computed Column To Have The Dates In A Column Presented In Users Specified Style (yyyy-mm-dd)

Yogi Anand, D.Eng, P.E.      Google Spreadsheet   Post  #783  Sep 28, 2012    www.energyefficientbuild.com.

user unicom said: (http://productforums.google.com/forum/?zx=d088tq41gvii#!category-topic/docs/spreadsheets/1Or85dznYHA
auto correcting a date format
Could anyone point me toward a help page or help me set up some kind of formula where by when customers insert a date into a form it can be automatically changed to produce one date format only.  Some choose for example dd.mm.yy or dd.m.yy or dd.mm.yyyy I have clear instructions as to how dates should be entered but invariably they are ignored and the various forms of date entry are accepted by the form and I end up manually correcting them.  I would like to either restrict entry to dd\mm\yyyy or create some kind of formula that automatically corrects it.  

Any suggestions would be welcome.

---------------------------------------------------------------------------------------------
I have assumed here that you had the column receiving the dates formatted as plain Text and the entries in the Form are acceptable date entries -- if the Form entries are not acceptable dates, then the problem would be a little more complex.