Can I convert Dated info on Spreadsheet to a Calendar view?

I have a spreadsheet that lists the date in mm-dd-yyyy format followed by several columns with related data for that date. It is in traditional spreadsheet format but I'l like to convert it to a standard monthly calendar view if possible. I'd like the day boxes in the calendar to reflect the correct day-of-week based on the date and then list info from a few of the cells associated with the corresponding date on the original SS.
Can this be done? I tried downloading a Calendar template and import the data but I must be doing something wrong....

Thanks
Timbo