days caculation
 

Hello



Is there a way you can calculate working days between two days rather that
all days?



Thanks

look at the NETWORKDAYS() function, which requires you have the Analysis
Toolpak installed (tools-Addins.. and make sure the Analysis Toolpak is
checked)


"Joe" wrote:

Hello



Is there a way you can calculate working days between two days rather that
all days?



Thanks

This formula will give you the number of weekdays Monday through Friday
which fall in the date interval A1 to B1 inclusive:

=SUMPRODUCT(INT((B1-A1+WEEKDAY(A1-{2,3,4,5,6}))/7))

The bracketed array constant gives the Weekday numbers associated with days
Monday through Friday. Change the bracketed array constant to get a count
for other sets of days. For example, use {1,7} for weekend days (Saturdays
and Sundays), or {2,4,6} for Mondays, Wednesdays, and Fridays.

This does not account for holidays. If you need to do this, prepare a list
of holidays and reply back for more help. (Although I don't use NETWORKDAYS,
I'm sure you'd have to do this in that case too).

"Joe" wrote:

Hello



Is there a way you can calculate working days between two days rather that
all days?



Thanks