| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Date copy & increment formula
I have a date, 1/23/2008, in C6 of worksheet "Joe"
I would like to see 1/29/2008 in C6 of worksheet "tom" when I go there. IE one week later date. Currently just typing it in. No biggie but is there a better way? Mel |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Date copy & increment formula
=Joe!C6 + 6 entered in C6 of sheet "tom"
I would most likely add 7 if I wanted a week later. Gord Dibben MS Excel MVP On Thu, 28 Feb 2008 16:33:57 -0800, "shakey" <shakeyATsonic.net wrote: I have a date, 1/23/2008, in C6 of worksheet "Joe" I would like to see 1/29/2008 in C6 of worksheet "tom" when I go there. IE one week later date. Currently just typing it in. No biggie but is there a better way? Mel |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Date copy & increment formula
=Joe!C6+6
HTH, JP On Feb 28, 7:33*pm, "shakey" <shakeyATsonic.net wrote: I have a date, 1/23/2008, in C6 of worksheet "Joe" I would like to see 1/29/2008 in C6 of worksheet "tom" when I go there. IE one week later date. Currently just typing it in. No biggie but is there a better way? Mel |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Date copy & increment formula
So easy.
Thank you both. Gord, Weeks just seem to fly by, only six days long. Mel "shakey" <shakeyATsonic.net wrote in message ... I have a date, 1/23/2008, in C6 of worksheet "Joe" I would like to see 1/29/2008 in C6 of worksheet "tom" when I go there. IE one week later date. Currently just typing it in. No biggie but is there a better way? Mel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy formula but only increment certain ranges? | Excel Discussion (Misc queries) | |||
| Exel increment date problem wrt todays date. | Excel Worksheet Functions | |||
| FORMULA TO INCREMENT 25 MONTHS BASED ON A DATE CELL | Excel Discussion (Misc queries) | |||
| copy increment by 1 | Excel Discussion (Misc queries) | |||
| How do you force a copy to increment by 1 in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
