Insert Dates for Year

[Guest]

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 O]

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.

 

[Dave O]

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.

 

[Dave Peterson]

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".

 

[Roger Govier]

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, Format>Cells>Number>Custom dddd, mmmm d, yyyy

Regards

Roger Govier

 

[Roger Govier]

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

 

[Guest]

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.

 

[Gord Dibben]

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