ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   one year calender (https://www.excelbanter.com/excel-discussion-misc-queries/66132-one-year-calender.html)

smickParisTX

one year calender
 
I want to setup a spreadsheet for a year that I can post information into
weekly. I want the dates setup weekly in a vertical format. I cannot get
it
to work using the instructions.



Michael

one year calender
 
Hi smickParisTX. Assuming you use Monday as the first day of the week, in A2
type 1/2/06. In A3 type 1/9/06. Select both cells A2 and A3 and point the
cursor at the little black box on the lower right corner of the selection.
When the cursor turns into a black cross, click and hold with the left button
and pull down. It will populate the cells in column as far as you go in
weekly increments. HTH
--
Sincerely, Michael Colvin


"smickParisTX" wrote:

I want to setup a spreadsheet for a year that I can post information into
weekly. I want the dates setup weekly in a vertical format. I cannot get
it
to work using the instructions.



smickParisTX

one year calender
 
This is exactly what I did, evidently I have a software problem. Thanks.

"Michael" wrote:

Hi smickParisTX. Assuming you use Monday as the first day of the week, in A2
type 1/2/06. In A3 type 1/9/06. Select both cells A2 and A3 and point the
cursor at the little black box on the lower right corner of the selection.
When the cursor turns into a black cross, click and hold with the left button
and pull down. It will populate the cells in column as far as you go in
weekly increments. HTH
--
Sincerely, Michael Colvin


"smickParisTX" wrote:

I want to setup a spreadsheet for a year that I can post information into
weekly. I want the dates setup weekly in a vertical format. I cannot get
it
to work using the instructions.



Michael

one year calender
 
Sorry about that. Good luck.
--
Sincerely, Michael Colvin


"smickParisTX" wrote:

This is exactly what I did, evidently I have a software problem. Thanks.

"Michael" wrote:

Hi smickParisTX. Assuming you use Monday as the first day of the week, in A2
type 1/2/06. In A3 type 1/9/06. Select both cells A2 and A3 and point the
cursor at the little black box on the lower right corner of the selection.
When the cursor turns into a black cross, click and hold with the left button
and pull down. It will populate the cells in column as far as you go in
weekly increments. HTH
--
Sincerely, Michael Colvin


"smickParisTX" wrote:

I want to setup a spreadsheet for a year that I can post information into
weekly. I want the dates setup weekly in a vertical format. I cannot get
it
to work using the instructions.



All times are GMT +1. The time now is 02:08 PM.

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