On Sun, 2 Oct 2005 15:25:02 -0700, "YaHootie"
wrote:

I need help on a function in a spreadsheet that will list all of the days in
a given month automaticaly with the entry of the 1st of the month only.

Ex;
10/01/05 entered dated
10/02/05 auto fill
10/03/05 "
. "
. "
10/31/05 end of auto fill

I would like the function to stop filling dates at end of the month even for
shorted months such as Feb.

Thank you in advance.


Enter 10/01/05 in A1and 11/01/05 in A2

(The UK interpretation of these dates are 10th and 11th January 2005,
although presumably it doesn't matter if you're posting from the US
and will be entering 10/01/05 and 10/02/05)

Select both dates then click and drag the small square handle on A2
down as far as necessary.

HTH




__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________