I am trying to get my Workdays and Networkdays formulas to work right. I am
measuring time in number of days, and calculating due dates and number of
workdays for cycles. I do not want to include weekends, holidays, or
adjustment number of days. I have set up a separate worksheet and entered our
holidays and named the column €œHolidays€� but the formula is not working when
I add that section to it. I dont actually have the holidays in the formula
because it is not working yet.

=IF(OR($L5="",$L5="NOT RECEIVED"),"",WORKDAY(Q5,U$1,Holidays)-Adj days)
=If part not received yet, then do nothing, else calculate the due date for
this cycle by adding the number of workdays allowed to the due date of the
last cycle, and do not include days listed in €œHolidays€� and subtract number
days for adjustment.

Do these actually give me only workdays?
WORKDAY(Q5,U$1,Holidays)-Adj days
=IF(BN4="","",NETWORKDAYS(L4,BN4,Holidays)-BU4) (This one is suppose to
count the total workdays use on entire project listed on row.)

This is the basic set up:
the number of
workdays allowed
for the cycle 10 22
Start Date Adjustments cycle 1 Due Date Repeats for cycles
Entered as # activities formula until
project done.

11/20/05 2 12/1/05 formula