How do I find total number workdays from a range of date

F

faisalm

I've to count total number working days from a range date; means I've to omit
off days (Friday & Saturday)
 
B

Bob Phillips

=NETWORKDAYS(start_date,end_date)

to include holidays, put them all in a range and add that

=NETWORKDAYS(start_date,end_date,holiday_range)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
B

Bob Phillips

Let's do that again

=NETWORKDAYS(start_date+1,end_date+1)

to include holidays, put them all in a range but add 1 to each date and use


=NETWORKDAYS(start_date+1,end_date+1,holidays_range)


This requires the Analysis Toolpak to be installed.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top