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?