Calculating a percentage of days in a term

[Guest]

Each semester I have to calculate what we call a 60% rule for withdrawal from
classes. I figured out the simple part of the formula (start date x .60
(plus the start date for the actual date)

My question is: How can I leave out certain weekends and holidays? I tried
using the WORKDAY or NETWORKDAYS formula without success. This would actually
a day or two on the result in some cases.

The other formula that could use help is the one that adds 3 days or 5 days
to the start date of a class NOT including weekends and holidays.

This is probably easy for most of you, but until now, I have only used Excel
more for information management and not calculations (or only simple ones)

Thank you in advance.

 

[daddylonglegs]

Sounds like you need WORKDAY function, why didn't that work? To add
workdays to a date in A1

=WORKDAY(A1,3)

You need to have Analysis Toolpak installed for WORKDAY to work
otherwise you'll get a #NAME? error