My goal is to automate making a calendar on Google Sheets. I used =DATE(C1,A1,B1)
to make a date and then each following cell, I added 1 to the previous cell.
However, now I want to also automate making a time table with this spreadsheet. To append my list of times from below, I used '&', but then the date 12/16/2018 became 43450.
3-4
4-5
5-6
6-7
7-8
8-9
9-10
What am I overlooking? Any help is appreciated.