I want to enter a first of the month start date that will fill in in a
vertical row of the rest of the dates in that month. It should not enter
dates such as 2/30/09

oldjay

Suppose you put the first date in A1, then in A2 you can enter this
formula:

=IF(A1="","",IF(MONTH(A1+1)<MONTH(A1),"",A1+1))

then copy this down to row 31.

Note that columns are vertical, not rows

Hope this helps.

Pete

On Feb 19, 6:41*pm, Oldjay wrote:
I want to enter a first of the month start date that will fill in in a
vertical row of the rest of the dates in that month. It should not enter
dates such as 2/30/09

oldjay

Hi
Type your date in one cell and put this formula in the next cell
=IF($A$2+COLUMN(B1)-1,$A$2+COLUMN(B1)-1,"")
You will need to adjust the starting cell A2 is the starting cell that you type
your date change it to your needs
HTH
John
"Oldjay" wrote in message
...
I want to enter a first of the month start date that will fill in in a
vertical row of the rest of the dates in that month. It should not enter
dates such as 2/30/09

oldjay

Put in the fisrt date, select the lower right corner of the cell and
drag down to auto-fill.

Oldjay wrote:
I want to enter a first of the month start date that will fill in in a
vertical row of the rest of the dates in that month. It should not enter
dates such as 2/30/09

oldjay

Put your first date in a cell (say A1)
then put:
=a1+1
and drag down as far as you need.

You could also put the date in the top cell
rightclick on the fill handle (bottom right corner of the cell)
and drag down.

When you let go of the mouse button, you'll be asked what you want--you can
choose fill days (or whatever you want).

Oldjay wrote:

I want to enter a first of the month start date that will fill in in a
vertical row of the rest of the dates in that month. It should not enter
dates such as 2/30/09

oldjay

--

Dave Peterson

Pete UK had the formula that I was looking for. It only shows dates in that
month.
Feb only shows dates thru the 28th and leaves the last 3 rows blank.
March shows dates in all 31 rows
I didn't check a leap year but I won't worryabout that now.

oldjay

"Dave Peterson" wrote:

Put your first date in a cell (say A1)
then put:
=a1+1
and drag down as far as you need.

You could also put the date in the top cell
rightclick on the fill handle (bottom right corner of the cell)
and drag down.

When you let go of the mouse button, you'll be asked what you want--you can
choose fill days (or whatever you want).

Oldjay wrote:

I want to enter a first of the month start date that will fill in in a
vertical row of the rest of the dates in that month. It should not enter
dates such as 2/30/09

oldjay

--

Dave Peterson

Thanks for feeding back - it will work for leap years as well.

Pete

On Feb 19, 9:41*pm, Oldjay wrote:
Pete UK had the formula that I was looking for. It only shows dates in that
month.
Feb only shows dates thru the 28th and leaves the last 3 rows blank.
March shows dates in all 31 rows
I didn't check a leap year but I won't worryabout that now.

oldjay

Hi Again
If its vertical this one will do. The first one was for horizontal
=IF($A$2+ROW(A1),$A$2+ROW(A1),"")
HTH
John
"Oldjay" wrote in message
...
I want to enter a first of the month start date that will fill in in a
vertical row of the rest of the dates in that month. It should not enter
dates such as 2/30/09

oldjay

=A1+1 and copy down.
--
David Biddulph

Oldjay wrote:
I want to enter a first of the month start date that will fill in in a
vertical row of the rest of the dates in that month. It should not
enter dates such as 2/30/09

oldjay