I am trying to create a spreadsheet with 5 sheets, there is going to be a date entered on sheet1, which will have a date+1 for the sequential days, i.e enter Monday's date and the following dates will enter correctly into the later weekdays. I am running into a problem where I've tried to format the cell as a date, but whatever date I enter it just has a 'random' one instead, like it's reading my input incorrectly. Whats the best way I can have a cell that I can enter 210916 as the date, it will auto-format to 21/09/16 or 21-09-16 and the formula for the sequential days on the other sheets? I keep getting number/text coercion issues as well.
How can I enter a date in the format I choose?
google spreadsheets;formatting