Hi,

In cell A1 enter
=A2
The choose Format, Cells, Number tab, Custom and enter DDDD on the Type line

In cell B2 enter
=EOMONTH(A2,0)

The EOMONTH function is part of the ATP in 2003 and earlier, so you need to
attach it by choosing Tools, Add-Ins, and check Analysis ToolPak.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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.