Help with Dates in Excel
hi
there is not a formula that will automaticaly insert the dates into column A
for an entire month. a macro might do this but formulas return values to the
cell in which they reside. they can not perform actions like "automaticaly
insert the dates into column A for an entire month". sorry.
but you can use formulas to do this.
in cell A1, enter the first day of the month.
in cell A2, enter this formula...=A1+1
copy cell A2 and copy down as far as needed.
regards
FSt1
"John" wrote:
I am looking to make a spreadsheet for an entire month. I know there is a
formula to automaticaly insert the dates into column A for an entire month.
Could some one help me remember this please!!
|