|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 12th, 2006, 07:36 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I autodate(excel) every 7 days ex. 1/1/06-1/31/06?
|
|
#2
January 12th, 2006, 10:23 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I autodate(excel) every 7 days ex. 1/1/06-1/31/06?
Enter 1/1/2006 in A1
In A2 enter =A1+7 Drag/copy down. Gord Dibben MS Excel MVP On Thu, 12 Jan 2006 11:36:03 -0800, "tlk1214" wrote:
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How can I calculate days (e.g., 180 days from 1/5/05)? | ACarter | Calendar | 2 | September 12th, 2005 10:26 PM |
| switch statement to calculate field | Nancy | Using Forms | 12 | May 18th, 2005 04:08 AM |
| Recurring Appointment - 5 days on, 2 days off | [email protected] | Calendar | 2 | April 4th, 2005 10:22 PM |
| How to calculate days:Hours:Minutes: | Kurewe | Worksheet Functions | 46 | January 17th, 2005 11:11 AM |
| Calculating date ranges | Tanya | Worksheet Functions | 9 | September 28th, 2004 09:21 PM |
Linear Mode
