Using weekdays only in a schedule

[alan]

We designed a worksheet that allows our assocaites to enter a due
date, and any number of steps to complete in days or weeks to compute
the start date. It's pretty simple, but there's no accounting for
weekends in the timeline.

The previous steps are calculated with
=(previous date)-(#of days+(number of weeks*days/week))

Is there any way to only count weekdays, Or subtract 1 if saturday or
2 if sunday?

I'm happy to forward the sheet to anyone interested.

Thanks

 

[Niek Otten]

Look at the WORKDAY() function.
See HELP for details.
If you get a #NAME error:
Tools>Add-ins, check Analysis Toolpak

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| We designed a worksheet that allows our assocaites to enter a due
| date, and any number of steps to complete in days or weeks to compute
| the start date. It's pretty simple, but there's no accounting for
| weekends in the timeline.
|
| The previous steps are calculated with
| =(previous date)-(#of days+(number of weeks*days/week))
|
| Is there any way to only count weekdays, Or subtract 1 if saturday or
| 2 if sunday?
|
| I'm happy to forward the sheet to anyone interested.
|
| Thanks

 

[alan]

So my formula is:


=E31-(C30+(B30*$M$33))

E31=next date
C30=# of Days
B30=# of weeks
$M$33=days per week

how would I write the formula with Weekday (I tried and couldn't do
it)

 

[Peo Sjoblom]

Niek said WORKDAY not WEEKDAY

=WORKDAY(Start_Date,Number_Of_Days,Public_Holidays)

so if you start on 08/01/07 in A1 and you want to add 30 weekdays

=WORKDAY(A1,30,H2:H12)

where H2:H12 is a list of public holiday dates

If you want the difference between 2 dates

=NETWORKDAYS(Date1,Date2,Public_Holidays)

 

[alan]

Thanks for your help. I'm a little thick, but t worked great.