Thread: Cell Value (Date) + number of days in VB
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default 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



Reply With QuoteReply With Quote