Cell Value (Date) + number of days in VB

's Computer Specifications

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

's Computer Specifications

Try this

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

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Corey" <(E-Mail Removed)> wrote in message news:uzXa9bH$(E-Mail Removed)...
>
> 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
>

's Computer Specifications

Thanks Ron

--
Regards

Corey

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Determine dates by number of days, "what date is 180 days from now	=?Utf-8?B?VFJMYW1i?=	Microsoft Outlook Calendar	2	19th Apr 2007 03:30 PM
Re: Excel Formula to calulate number of days passed from date to date	Dave Peterson	Microsoft Excel Misc	2	4th Jan 2007 11:27 PM
Re: Excel Formula to calulate number of days passed from date to date	Nick Hodge	Microsoft Excel Misc	0	4th Jan 2007 09:17 PM
Re: Excel Formula to calulate number of days passed from date to date	Roger Govier	Microsoft Excel Misc	0	4th Jan 2007 09:14 PM
calculate number of days from start date to date completed?	=?Utf-8?B?TGluZGE=?=	Microsoft Outlook Discussion	2	24th Feb 2006 08:09 PM