Thread: extending dates
View Single Post
  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

I'm don't think you can change this.

But you could use a formula and drag that:

=date(year(a1),month(a1)+1,1)



Sanford Lefkowitz wrote:

When I have a date in a cell (say,Jan01) and use the fill handle to drag it
down, by default, it seems to fill with days. If I click the tag next to the
list, I can check 'fill months' to get the list I want.

Can I make 'fill months' the default?

Thanks
Sanford


--

Dave Peterson