Auto Updating Date

[Jfirestone]

Here is my question.

I have a huge Gantt Chart that takes up the entire width excel will allow. Each day, A1 updates to display the current day. Then I have to Fill: Series: Weekday to get it to update B1--> the end of my chart correctly.

Is there a way to do it automatically? Making each cell to the right A1+1, B1+1..Z1+1 obviously doesn't work because it adds the weekend days which I do not need for production purposes. I can't do A1+1, A1+2...A1+4, A1+7, because obviously on Monday A1+4 is Friday, but on tuesday, A1+4 would be Saturday.

So, can I do it? or Am I stuck doing it manually?

Thanx!

 

[Mark W.]

You mean like this...

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	10/14/2002	10/15/2002	10/16/2002	10/17/2002	10/18/2002	10/21/2002	10/22/2002	10/23/2002	10/24/2002	10/25/2002	10/28/2002
2	Mon	Tue	Wed	Thu	Fri	Mon	Tue	Wed	Thu	Fri	Mon
3
4
Sheet2

This message was edited by Mark W. on 2002-10-17 17:40

 

[Jfirestone]

That is EXACTLY what I mean!

Thank you very very much! I knew there had to be a way to do it!

I appreciate the help!

Jed

 

[nehpets12]

You Could Use Workdays

Book4
	A	B	C	D	E	F	G	H	I	J	K
1	14/10/2002	15/10/2002	16/10/2002	17/10/2002	18/10/2002	21/10/2002	22/10/2002	23/10/2002	24/10/2002	25/10/2002	28/10/2002
2	Mon	Tue	Wed	Thu	Fri	Mon	Tue	Wed	Thu	Fri	Mon
3
Sheet1