How calculate Weekday dates??

[Guest]

I am looking for the formula where I can enter a date and excel will
calculate and display all consecutive dates in column form that are WEEKDAYS
only.

Example:
I enter 09/06/04 in cell A1

Excel Claculates and Displays below A1:
09/07/04
09/08/04
09/09/04
09/10/04
09/13/04
etc

Notice how I want it to omitt 09/11/04 and 09/12/04.

What is the formula?

 

[Myrna Larson]

Put the first date, 9/6/04 in A1.

Then go to the Edit menu, select Fill, then Series, then select the WEEKDAY
option.

If you need to account for holidays, in A2 put the formula,

=WORKDAY(A1,1,HolidayList)

and copy it down. HolidayList would be a range containing the list of
holidays. Check out the function in Help. Note that it's in the Analysis Tool
Pak. Help tells you how to install that if you haven't done so.

 

[Guest]

Thanks Myrna:

You are my hero!

Paul