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.