View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Filling in specific dates in Excel

Oops

It is Left - right

filldown with your right button


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ron de Bruin" wrote in message ...
In A1 : 1/1/2007
In A2 : 1/15/2007

Select both cells and copy down with your mouse but not with your right mouse button
but with your left button.
When you release your mouse you see a dialog with the option "Fill months"




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message ...
I recieve income on the 1st and the 15th of every month, regardless of
the month, or day.

Understanding the serial number feature of Excel, I cannot create a
autofill that will fill in the 1st and 15th of every month.

I need to be able to type in the 1st of a month then autofill across
and have it pick up the 1st and 15th of every month.

How can this be performed?