7 Day Automatic Imput

[Matlock]

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?

 

[Alan]

With date in G3, in G26 enter =G3+1 ; in G49 enter =G3+2 ; in G72 enter
=G3+3 and so on, make sure all these cells have the same formatting as G3,
Regards,
Alan.

 

[Cimjet]

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]

That formula works well. But is there any way for it to just show (1st,
2nd...ext) insted of just 1, 2, 3.

 

[Alan]

It doesn't show 1, 2, 3. If you enter 6/3/08 in G3, in G26 with =G3+1 the
formula will return 7/3/08, not sure what your looking for here to tell the
truth,
Regards,
Alan.

 

[Matlock]

I am looking for a way to type in 1st (with the 'st') and then the 2nd (with
the 'nd') comes up for the next date. Insted of 2, or 2/2/02 or 2/2.

I type '1' and it turns it into '1st'.

Or..

Is there a way to type in a colum of dates 1st - 31st with the letters after

example...
1st
2nd
3rd
4th
5th
6th

And possibly have a formula so when I type '1st' in one cell, the next cell
automaticly imputs the next number down the colum.
Another way to look at it is..

Jay
Billy
Kevin

I type in 'Billy' and 'Kevin' automaticly is placed in the next paticular
cell?

Fallow?