View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
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!!