How to add days of the month

[NoNoBadDog!]

Okay, I am new to using Excel. I have a sheet that I want the days of the
month in column 1. I am using this sheet to track mileage for tax purposes.
I have figured out how to set up the formulas for the mileage, but cannot
for the life of me figure out how to have Excell make column 1 the days of
the month without having to type each day individually. I have seen it done
where the formula is added in the first row and then copied down the column,
and it automatically adds the dates (10/01/2003, 10/02/2003, etc). How is
this done? It's really driving me crazy cause I am sure it is something
very simple that I am just overlooking.

Bobby

 

[Kate G.]

Type the date in the top cell. Enter it. Now take your cursor and place it
over the bottom right hand corner of the cell --over the little square
"button" -- called the "FILL HANDLE".

Click and drag down. That should do the trick for you. It also works if
you were to pull it to the right. This can be a VERY convenient tool!

That should do the trick for you!

Kate in MN