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

[Guest]

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

 

[Biff]

See this:

http://tinyurl.com/lml72

Biff

 

[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)

 

[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)