Counting weekdays
Posted by Matthew Schmnitt on April 06, 2001 11:20 AM
I have a spreadsheet where we enter in outstanding recon items. What I need to do is count the days between today, and whenever the item was entered on the the outstanding items sheet. User inputs date when item is entered. However, I do not need to count Saturday or Sunday, or some holidays. Only Monday through Friday(again, holidays not included).
Posted by Matthew Schmitt on April 06, 2001 11:38 AM
One thing I forgot to mention was that I went through the Excel help screens, and tried using NETWORKDAYS in the exact format as on the help example, but I got a #NAME? error as the result
Posted by Aladin Akyurek on April 06, 2001 11:38 AM
=NETWORKDAYS(A1,TODAY(),HOLIDAYS)
A1 contains the date an given item is entered.
HOLIDAYS is the name of the range where you enter the dates for holidays that you want to exclude from the count.
Note that you need Analysis Toolpak in order to use this function. See the option Tools|Add-ins.
Aladin
Posted by Matthew Schmitt on April 06, 2001 1:58 PM
OK, after playing around some more(my analsys tool pak wasn't checked in my addins), I was able to get the sheet to properly calculate the number of days. However(it always seems like there is a however)I need to reference a particular cell, instead of a date in quotes. Is that possible?
Posted by Matt Schmitt on April 06, 2001 2:01 PM
Posted by Aladin Akyurek on April 06, 2001 2:16 PM
Matthew: You can use the following construction.
=NETWORKDAYS(VALUE("01-04-01"),TODAY(),Holidays)
Aladin
