Enter a date in A1

Select A1:A20 and EditFillSeries

Choose from options.

Do you want an increment of one day, weekday, one week, step of 2 or
wharever?

Play with it and see the various fills.


Gord Dibben MS Excel MVP

On Sat, 1 May 2010 02:00:01 -0700, Caz
wrote:

Hi,

I am trying to find more info on how to use the functions on the Fill
Command in the Editing group especially regarding dates as I cannot seem to
get this to work.

I know how to fill using the drag handle but would also like to use the fill
command.

If anyone can guide me to a site which discusses this command that would be
good.

Thanks