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" wrote in message
...
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
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