Excel running date formula minus weekend days

I have created a calendar in excel.
Row 1 shows the days of the week in text format with this formula:
=TEXT(WEEKDAY(B2),"dddd"
Row 2 shows a future date April 4, 2005 (I created running dates across the
row by clicking and dragging)
Each month is on a separate worksheet (whcih can be changed if needed).

Question: What formula can I use to create running dates (right now they are
future dates) for each month that will allow me to skip Saturday and Sunday?
I need to display weekdays only, but would like to have everything automated
so that I don't have to go in and delete the weekends for each month.

Thanks for the help!!

Say your strating date entered is on cell A1 then on cell A2 enter
=IF(WEEKDAY(A1+1,2)<6,A1+1,IF(WEEKDAY(A1,2)=6,A1+2,A1+3))
and copy it downwards
It will produce a list of all weekdays
Format it as "dddd" if you need days of the week

"Eliane" <Eliane@discussions.microsoft.com> wrote in message
news:F428B887-B267-4BE1-8091-8FD7850FF138@microsoft.com...
>I have created a calendar in excel.
> Row 1 shows the days of the week in text format with this formula:
> =TEXT(WEEKDAY(B2),"dddd"
> Row 2 shows a future date April 4, 2005 (I created running dates across
> the
> row by clicking and dragging)
> Each month is on a separate worksheet (whcih can be changed if needed).
>
> Question: What formula can I use to create running dates (right now they
> are
> future dates) for each month that will allow me to skip Saturday and
> Sunday?
> I need to display weekdays only, but would like to have everything
> automated
> so that I don't have to go in and delete the weekends for each month.
>
> Thanks for the help!!

On Wed, 30 Mar 2005 11:11:02 -0800, Eliane <Eliane@discussions.microsoft.com>
wrote:

>I have created a calendar in excel.
>Row 1 shows the days of the week in text format with this formula:
>=TEXT(WEEKDAY(B2),"dddd"
>Row 2 shows a future date April 4, 2005 (I created running dates across the
>row by clicking and dragging)
>Each month is on a separate worksheet (whcih can be changed if needed).
>
>Question: What formula can I use to create running dates (right now they are
>future dates) for each month that will allow me to skip Saturday and Sunday?
>I need to display weekdays only, but would like to have everything automated
>so that I don't have to go in and delete the weekends for each month.
>
>Thanks for the help!!

If your starting date is in A1:

=WORKDAY(A1,1)

If the WORKDAY function is not available, and returns the #NAME? error, install
and load the Analysis ToolPak add-in.

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click
OK.
If necessary, follow the instructions in the setup program.

--ron