View Single Post
  #2  
Old November 11th, 2009, 04:22 AM posted to microsoft.public.excel.misc
FSt1
external usenet poster
 
Posts: 2,788
Default 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!!