Hi Matlock
Not suse if I got you well but if you put in cell G26 =G3+1 and in G49
=G3+2 and so on you should get what I believe you want.
Post back if not.
Regards
Cimjet
"Matlock" wrote in message
...
On my Schedule Creator my business uses, I'd like to be able to type in a
date once (ex: 1st..) then in the seperate cells, it automatically inserts
the next six days for that week, in different cells. Without us having to
type in each individual day ourselves.

Day one is in G3... then day two is in G26.. then, G49, G72, G95, G118,
G141.

Is there any formula for this?