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