| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I set up a sheet with date headers one week apart.
I am trying to set up a spreadsheet with date headers and/or side labels,
one week apart. I have tried without success. Any help gratefully received. 1/1/2006 - 8/1/2006 - 15/1/2006 etc. Frank Taylor Dell Dimension 8400 4 Gig RAM 1.3 GigHz Pentium CPU Multithreaded Windows XP Pro - SR2 Canon S530D 160 Gig Hard Drive. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I set up a sheet with date headers one week apart.
Hi
Type your first date in A2. In the next cell use = A2+7 You can fill this across as necessary. Andy. "mossbury" wrote in message ... I am trying to set up a spreadsheet with date headers and/or side labels, one week apart. I have tried without success. Any help gratefully received. 1/1/2006 - 8/1/2006 - 15/1/2006 etc. Frank Taylor Dell Dimension 8400 4 Gig RAM 1.3 GigHz Pentium CPU Multithreaded Windows XP Pro - SR2 Canon S530D 160 Gig Hard Drive. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I set up a sheet with date headers one week apart.
Hi Andy,
How do I fill the remaining ones. Do I have to type in each column seperately? Frank "Andy" wrote: Hi Type your first date in A2. In the next cell use = A2+7 You can fill this across as necessary. Andy. "mossbury" wrote in message ... I am trying to set up a spreadsheet with date headers and/or side labels, one week apart. I have tried without success. Any help gratefully received. 1/1/2006 - 8/1/2006 - 15/1/2006 etc. Frank Taylor Dell Dimension 8400 4 Gig RAM 1.3 GigHz Pentium CPU Multithreaded Windows XP Pro - SR2 Canon S530D 160 Gig Hard Drive. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I set up a sheet with date headers one week apart.
Frank
If you select the cell which in which you have typed =A2+7, there will be a little black square in the bottom right hand corner. Move your mouse over it and it becomes a cross. You can drag this cross along the row to copy the formula across. Andy. "mossbury" wrote in message ... Hi Andy, How do I fill the remaining ones. Do I have to type in each column seperately? Frank "Andy" wrote: Hi Type your first date in A2. In the next cell use = A2+7 You can fill this across as necessary. Andy. "mossbury" wrote in message ... I am trying to set up a spreadsheet with date headers and/or side labels, one week apart. I have tried without success. Any help gratefully received. 1/1/2006 - 8/1/2006 - 15/1/2006 etc. Frank Taylor Dell Dimension 8400 4 Gig RAM 1.3 GigHz Pentium CPU Multithreaded Windows XP Pro - SR2 Canon S530D 160 Gig Hard Drive. |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I set up a sheet with date headers one week apart.
Andy,
I have done this, I just get the "#VALUE" in every other cell. A1 B1 C1 D1 etc 23.1.2006 =A1+7 #VALUE #VALUE Using the same procedure in Open Office Calc works fine. No luck with Excell2003 Frank "Andy" wrote: Frank If you select the cell which in which you have typed =A2+7, there will be a little black square in the bottom right hand corner. Move your mouse over it and it becomes a cross. You can drag this cross along the row to copy the formula across. Andy. "mossbury" wrote in message ... Hi Andy, How do I fill the remaining ones. Do I have to type in each column seperately? Frank "Andy" wrote: Hi Type your first date in A2. In the next cell use = A2+7 You can fill this across as necessary. Andy. "mossbury" wrote in message ... I am trying to set up a spreadsheet with date headers and/or side labels, one week apart. I have tried without success. Any help gratefully received. 1/1/2006 - 8/1/2006 - 15/1/2006 etc. Frank Taylor Dell Dimension 8400 4 Gig RAM 1.3 GigHz Pentium CPU Multithreaded Windows XP Pro - SR2 Canon S530D 160 Gig Hard Drive. |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I set up a sheet with date headers one week apart.
Hi
If you click in a cell with #VALUE, what does the formula bar say is the formula in the cell. Each column should increment on the previous, so =A1+7 becomes =B2+7, which becomes =B3+7 Also, is your starting cell an Excel date? The usual way they display is dd/mm/yyyy (for English). It should be really easy! Andy. "mossbury" wrote in message ... Andy, I have done this, I just get the "#VALUE" in every other cell. A1 B1 C1 D1 etc 23.1.2006 =A1+7 #VALUE #VALUE Using the same procedure in Open Office Calc works fine. No luck with Excell2003 Frank "Andy" wrote: Frank If you select the cell which in which you have typed =A2+7, there will be a little black square in the bottom right hand corner. Move your mouse over it and it becomes a cross. You can drag this cross along the row to copy the formula across. Andy. "mossbury" wrote in message ... Hi Andy, How do I fill the remaining ones. Do I have to type in each column seperately? Frank "Andy" wrote: Hi Type your first date in A2. In the next cell use = A2+7 You can fill this across as necessary. Andy. "mossbury" wrote in message ... I am trying to set up a spreadsheet with date headers and/or side labels, one week apart. I have tried without success. Any help gratefully received. 1/1/2006 - 8/1/2006 - 15/1/2006 etc. Frank Taylor Dell Dimension 8400 4 Gig RAM 1.3 GigHz Pentium CPU Multithreaded Windows XP Pro - SR2 Canon S530D 160 Gig Hard Drive. |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I set up a sheet with date headers one week apart.
Hi Frank
It sounds like your cell B1 is formatted as text, hence the formula shows rather than the result of the formula. Delete the entry in B1. FormatCellsNumberGeneral Retype =A1+7 Change the entry in A1 to 23/01/2006 -- Regards Roger Govier "mossbury" wrote in message ... Andy, I have done this, I just get the "#VALUE" in every other cell. A1 B1 C1 D1 etc 23.1.2006 =A1+7 #VALUE #VALUE Using the same procedure in Open Office Calc works fine. No luck with Excell2003 Frank "Andy" wrote: Frank If you select the cell which in which you have typed =A2+7, there will be a little black square in the bottom right hand corner. Move your mouse over it and it becomes a cross. You can drag this cross along the row to copy the formula across. Andy. "mossbury" wrote in message ... Hi Andy, How do I fill the remaining ones. Do I have to type in each column seperately? Frank "Andy" wrote: Hi Type your first date in A2. In the next cell use = A2+7 You can fill this across as necessary. Andy. "mossbury" wrote in message ... I am trying to set up a spreadsheet with date headers and/or side labels, one week apart. I have tried without success. Any help gratefully received. 1/1/2006 - 8/1/2006 - 15/1/2006 etc. Frank Taylor Dell Dimension 8400 4 Gig RAM 1.3 GigHz Pentium CPU Multithreaded Windows XP Pro - SR2 Canon S530D 160 Gig Hard Drive. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Value between 2 dates | Excel Worksheet Functions | |||
| Date & Day of Week | Excel Discussion (Misc queries) | |||
| Sheet Modified date in a cell.. ? | Excel Worksheet Functions | |||
| I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
| Returning the Week Number of a Specific Date on a Month | Excel Worksheet Functions | |||
Hybrid Mode
