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?