Cell Value (Date) + number of days in VB

[Corey]

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

 

[Ron de Bruin]

Try this

Range("E2").Value = Range("E2").Value +7

 

[Corey]

Thanks Ron