You can't really autmate this without first creating the formulas, assume A2
would the cell with the start date, then you can refer to this cell in the
other cells like

=IF(A2="","",A2+1) (will add one day to the date in A2 unless A2 is empty
and so on)

I am afraid you need to to do some manual work first and then it will look
like it is
automated later.

Regards,

Peo Sjoblom

"Aviator" wrote:

I am trying to do something with dates on exel. The problem is that we work a
4 X 10 schedule. I want to be able to type in a start date and have the rest
of the dates automaticly fill in. I guess there is two things I am trying to
learn.

1. How do I make it so dates automaticly fill in?
2. How do I make it fill in using a 4 X 10 schedule?

Please Help!

Thank you,

Aviator