Ftll in dates

[Oldjay]

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

 

[Pete_UK]

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

 

[John]

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

 

[Dave Peterson]

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

 

[Bob I]

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

 

[John]

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]

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

 

[Pete_UK]

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

Pete