Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
7 Day Automatic Imput
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
7 Day Automatic Imput
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. "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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
7 Day Automatic Imput
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
7 Day Automatic Imput
That formula works well. But is there any way for it to just show (1st,
2nd...ext) insted of just 1, 2, 3. "Alan" wrote: 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. "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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
7 Day Automatic Imput
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" wrote in message ... That formula works well. But is there any way for it to just show (1st, 2nd...ext) insted of just 1, 2, 3. "Alan" wrote: 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. "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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
7 Day Automatic Imput
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select data to imput to macro | Excel Discussion (Misc queries) | |||
Select data to imput to macro | Excel Discussion (Misc queries) | |||
Autocorrecting my Number imput | Excel Discussion (Misc queries) | |||
Automated imput partly | Excel Worksheet Functions | |||
two-imput data table | Excel Worksheet Functions |