Insert Dates for Year
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?
|