Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating a percentage of days in a term
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating a percentage of days in a term
Sounds like you need WORKDAY function, why didn't that work? To add 3 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. -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=551061 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Number of days from one date to another | Excel Discussion (Misc queries) | |||
calculating number of days (e.g., Mondays) between two dates | Excel Worksheet Functions | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
Calculating Production/Man Days in Excel | Excel Discussion (Misc queries) | |||
Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions |