PC Review


Reply
Thread Tools Rate Thread

Cell Value (Date) + number of days in VB

 
 
Corey
Guest
Posts: n/a
 
      30th Oct 2006

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 Quote
 
 
 
 
Ron de Bruin
Guest
Posts: n/a
 
      30th Oct 2006
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
>



 
Reply With Quote
 
Corey
Guest
Posts: n/a
 
      30th Oct 2006
Thanks Ron

--
Regards

Corey


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:59 AM.