| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Value (Date) + number of days in VB
I Have a Cell Value that is a Date (31/10/2006), but i want a code that will add say 7 days to this date. I have tried something like: range("E2").cellvalue+7 but errors I am sure it is simple but i cannot manage to get it to work as yet. Regards Corey |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cell Value (Date) + number of days in VB
Try this
Range("E2").Value = Range("E2").Value +7 -- Regards Ron de Bruin http://www.rondebruin.nl "Corey" wrote in message ... I Have a Cell Value that is a Date (31/10/2006), but i want a code that will add say 7 days to this date. I have tried something like: range("E2").cellvalue+7 but errors I am sure it is simple but i cannot manage to get it to work as yet. Regards Corey |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cell Value (Date) + number of days in VB
Thanks Ron
-- Regards Corey |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Formula for number of days between a date and today | Excel Discussion (Misc queries) | |||
| business day date from a specific date based on a number of days | Excel Worksheet Functions | |||
| calculate a date X number of days before/after given date | Excel Worksheet Functions | |||
| Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
| Number of days since a date | New Users to Excel | |||
Hybrid Mode
