| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date "E2" to add 7 days How?
I think this is quite simple but i want to create a short code to add 7 days
to a date in cell E2. The cell is formatted so it display a date in a 31 October 2006 view. Please help. Regards Corey |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date "E2" to add 7 days How?
Never mind worked it out.
activecell.FormulaR1C1 = [E2] + 7 Regards Corey |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date "E2" to add 7 days How?
How about adding 7 days to ALL sheets that have a date in Cell E2 ?
-- Regards Corey |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date "E2" to add 7 days How?
Ok, i have done it the hard way by a macro for each sheet.
But i have a max on 3 other sheets (Not Yet Created) that i need the cell E2 to have 7 days added to also. I want to add a step to the below code for each sheet, that checks to see if that sheets exists 1st. If not then exits sub. ~~~~~~~~~~~~~~~~~~~ Sub Sheet15UpdateDate() Sheet15.Select ' <=================== How do i check to see if this is a sheet or not 1st ??? Range("E2").Activate If Range("E2").Value < "" Then activecell.FormulaR1C1 = [E2] + 7 End If Sheet4.Select End Sub ~~~~~~~~~~~~~~~~~~ -- Regards |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date "E2" to add 7 days How?
solved
Corey |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to go "X" number of days out from a undefined date? | Excel Discussion (Misc queries) | |||
| get a runing total for"curent date"or(cell)minus prev 30 days( cel | Excel Worksheet Functions | |||
| can we convert "2 days 16 hrs" to " 64hrs" using excel functions | Excel Worksheet Functions | |||
| "DAYS 360" and the date Feb 28th as start and end | Excel Worksheet Functions | |||
| TODAY'S DATE PLUS "BUSINESS" DAYS | Excel Programming | |||
Linear Mode
