I would like to insert a date for every work date Monday through Friday for
2006.

I would like it to be formatted as - Monday, January 2, 2006

I put in the first week and did autofill and it autofills but changes the
year. I need it to Put in the next work week through out the year?

How can I accomplish this?

Here's one way: enter the first work day of the year, 1/2/2006, in cell
A1. Enter this formula in A2:
=WORKDAY(A1,1)
.... and format it to show day and date. The WORKDAY function returns
the workday that is a number of days after the value in A1.

Here's one way: enter the first work day of the year, 1/2/2006, in cell
A1. Enter this formula in A2:
=WORKDAY(A1,1)
.... and format it to show day and date. The WORKDAY function returns
the workday that is a number of days after the value in A1. You can
also enter a list of holidays or other days to ignore, if you choose.

Put January 2, 2006 in A1. (I'd use 01/02/2006 with my USA settings).

Then format that cell:
format|Cells|Number tab|custom category:
dddd, mmmm d, yyyy

Then use that little autofill button on the bottom right corner of the selected
cell.

Rightclick on it and drag down.
When you let go, you'll be prompted for a choice. Choose "Fill Weekdays".



Gladys wrote:

I would like to insert a date for every work date Monday through Friday for
2006.

I would like it to be formatted as - Monday, January 2, 2006

I put in the first week and did autofill and it autofills but changes the
year. I need it to Put in the next work week through out the year?

How can I accomplish this?

--

Dave Peterson

Hi Gladys

In cell A1 enter 02/01/2006 or whatever is the format for your regional
setting for 2nd January.
In cell A2 enter
=Workday($A$1,Row()-1)
Copy down column A as far as required.
Format column A, FormatCellsNumberCustom dddd, mmmm d, yyyy

Regards

Roger Govier


Gladys wrote:
I would like to insert a date for every work date Monday through Friday for
2006.

I would like it to be formatted as - Monday, January 2, 2006

I put in the first week and did autofill and it autofills but changes the
year. I need it to Put in the next work week through out the year?

How can I accomplish this?

Hi Dave

There's none so blind as those that cannot see!!!
I've never noticed that option before. The wipers have now been switched on<g.

Regards

Roger Govier


Dave Peterson wrote:
Put January 2, 2006 in A1. (I'd use 01/02/2006 with my USA settings).

Then format that cell:
format|Cells|Number tab|custom category:
dddd, mmmm d, yyyy

Then use that little autofill button on the bottom right corner of the selected
cell.

Rightclick on it and drag down.
When you let go, you'll be prompted for a choice. Choose "Fill Weekdays".



Gladys wrote:

I would like to insert a date for every work date Monday through Friday for
2006.

I would like it to be formatted as - Monday, January 2, 2006

I put in the first week and did autofill and it autofills but changes the
year. I need it to Put in the next work week through out the year?

How can I accomplish this?

Thanks for the help. One more thing though - Is there a easy way to put this
date at the top a new page.

I need a page with the Current Days Date for Every Work day of the Year.
Page 1 would be Monday, January 2, 2006
Page 2 would be Tuesday, January 3, 2006 etc
all the way through Friday, December 9, 2006.

"Gladys" wrote:

I would like to insert a date for every work date Monday through Friday for
2006.

I would like it to be formatted as - Monday, January 2, 2006

I put in the first week and did autofill and it autofills but changes the
year. I need it to Put in the next work week through out the year?

How can I accomplish this?

Gladys

What do you consider a "page"?

A section of say every 40 rows on one worksheet?

Enter the Jan 02, 2006

Select A1:A41

Drag down using right button for about 11000 rows. Release button and "Fill
Weekdays"

You will have a new day every 40 rows.


Gord Dibben Excel MVP

On Wed, 7 Dec 2005 10:09:03 -0800, Gladys
wrote:

Thanks for the help. One more thing though - Is there a easy way to put this
date at the top a new page.

I need a page with the Current Days Date for Every Work day of the Year.
Page 1 would be Monday, January 2, 2006
Page 2 would be Tuesday, January 3, 2006 etc
all the way through Friday, December 9, 2006.

"Gladys" wrote:

I would like to insert a date for every work date Monday through Friday for
2006.

I would like it to be formatted as - Monday, January 2, 2006

I put in the first week and did autofill and it autofills but changes the
year. I need it to Put in the next work week through out the year?

How can I accomplish this?