Calculating days and dates

[HDV]

I need to calculate the number of working days (ie Monday to Friday) from the date entered in cell D4 (22/07/2005). This needs to update each day in cell E4.

I can do this not based on working days, by entering

=DATEDIF(D4,TODAY(),"d")

but where in the formula do I reference it to working days or network days? HELP!

[swatsp0p]

You can use the NETWORKDAYS function to do what you ask.

=NETWORKDAYS(D4,TODAY(),E4:E10)

where D4 is the start date and E4:E10 is a list of holidays (entered in valid date format) to exclude from your count (optional, omit or adjust the range to meet your needs).

In your example, 17 is returned with TODAY() being 15Aug2005 and no holidays counted in this timeframe. Note that it counts the first day in the range as day 1 and the last day listed is also counted.)

I believe you need to have the Analysis Tool Pack Add-In installed to have the function available. Click Tools>Add-ins and place a check by this item and click OK.

HTH

Bruce