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 and the formula for the sequential days on the other sheets? I keep getting number/text coercion issues as well.