Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Date.
I notice that when I put a date and drag the little square in the bottom
right of the cell to adjacent cells, the other cells will have a date increment by one day. However, how do I do this when the cell is not adjacent and far apart? Another question, If I have two cell that are not adjacent and I want to add the date (9-23-04) for the beginning of the week which is Monday and the date for the end of the week which is sunday, How do I do this with 7 days range but within only two 2 cells? Thanks |
#2
Posted to microsoft.public.excel.charting,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Date.
Hi
see your other post -- Regards Frank Kabel Frankfurt, Germany "Raymond" schrieb im Newsbeitrag ... I notice that when I put a date and drag the little square in the bottom right of the cell to adjacent cells, the other cells will have a date increment by one day. However, how do I do this when the cell is not adjacent and far apart? Another question, If I have two cell that are not adjacent and I want to add the date (9-23-04) for the beginning of the week which is Monday and the date for the end of the week which is sunday, How do I do this with 7 days range but within only two 2 cells? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate including a date so that the date appears as a date | Excel Worksheet Functions | |||
date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
Making a date go red, if date passes todays date. | Excel Worksheet Functions | |||
Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel |