Formula in A1:
=DAY(A2)
Custom format as:
dddd
Fomrula in B2:
=IF(A2="","",IF(MONTH(A2+1)=MONTH(A2),A2+1,""))
Format as using desired date format, copy to the right at least 31 cells.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"ann" wrote:

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.