ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Date. (https://www.excelbanter.com/excel-programming/311176-date.html)

Raymond[_8_]

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



Frank Kabel

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





All times are GMT +1. The time now is 12:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com