I would like to create a spreadsheet so that when I enter a date cells to the
right automatically fill with the remaining days of the month by date and
also the actual name of the day of the month.

Ex:

Enter in 1/01/2009 in cell A2, cells to the right fill to 1/31/2009.
Then in cell A1 the name of the day of the month would fill in such as Monday.

Thanks.