Date

's Computer Specifications

I have an excel sheet where in cell A1 I have "01/02/2006 to 01/08/2006 (Week
1)" and from cell G11, H11, I11,...,M11, I have the corresponding number for
the dates given; In this case G11~M11 contains the numbers 2~8. Now I want to
add a button called "next week". The function of this button will be to
change cell A1 and G11~M11 to the following week automatically.

How can I overcome this. Please HELP

's Computer Specifications

First, go to the correct news group. You are asking an Excel question in an
Access group. I'm sure you will get a better answer there.

"Himu" wrote:

> I have an excel sheet where in cell A1 I have "01/02/2006 to 01/08/2006 (Week
> 1)" and from cell G11, H11, I11,...,M11, I have the corresponding number for
> the dates given; In this case G11~M11 contains the numbers 2~8. Now I want to
> add a button called "next week". The function of this button will be to
> change cell A1 and G11~M11 to the following week automatically.
>
> How can I overcome this. Please HELP
>
>

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
what method to use to add 1 day to a date (hotel reservation for one night by clicking on calender) and get it displayed in date formate in a textbox for departure date?	Amanda	Microsoft VB .NET	2	10th Oct 2006 07:52 AM
Link date to a table with Date Range (Eff Date and term date)	=?Utf-8?B?S2V2aW4gUmVlZA==?=	Microsoft Access	1	31st Aug 2006 05:23 PM
i have two date fileds Opend date Due date, can i set default on due date so, its always = to open date on my data entry form1 Urgent	Mike Saifie	Microsoft Access Form Coding	1	9th Mar 2006 02:08 AM
Run Query from date to date, Print the from date to date in the header of the report?	Dustin Swartz	Microsoft Access Queries	1	25th Jan 2005 08:06 PM
Date fields automatically changing when today date matches date field entry.Help!	Brian Cassin	Microsoft Access Forms	1	15th Nov 2003 02:51 PM