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

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

Cell Value (Date) + number of days in VB
 

Thanks Ron

--
Regards

Corey