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 i
valid date format) to exclude from your count (optional, omit or adjus
the range to meet your needs).

In your example, 17 is returned with TODAY() being 15Aug2005 and n
holidays counted in this timeframe. Note that it counts the first da
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 t
have the function available. Click Tools>Add-ins and place a check b
this item and click OK.

HTH

Bruc