| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a way to create dates 7 days apart automatically?
As it turned out I took Gary's advice and it worked out great! Thanks Gary!!! On Thu, 22 Dec 2005 09:57:25 -0500, "Gary Keramidas" <GKeramidasATmsn.com wrote: not sure what you want to accomplish. put 1/1/06 in a1, 1/8/06 in b1, select both cells, click and drag the box in the lower right corner of b1 (mouse pointer changed to a +) as far across as you want to go. On Thu, 22 Dec 2005 17:26:55 -0800, wrote: Hiya, I'm trying to create a timesheet for myself. 1/1/06 - 1/8/06 1/9/06 - 1/16/06 | | | | | | And ending at: December 31, 2006. (or there abouts.) I don't know if it's possible, but I'd love for Excel to fill in the blanks so I don't have to. Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help to create biweekly dates excluding nonworking days | Excel Discussion (Misc queries) | |||
| Calc days between two dates and exclude leap year days | Excel Worksheet Functions | |||
| Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
| Automatically calculate days between dates | Excel Worksheet Functions | |||
| Calculating # of busn days, not just calendar days, between 2 dates? | Excel Programming | |||
Hybrid Mode
