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

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

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

See this:

http://tinyurl.com/lml72

Biff

"faisalm" wrote in message
...
I've to count total number working days from a range date; means I've to
omit
off days (Friday & Saturday)

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

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

"faisalm" wrote in message
...
I've to count total number working days from a range date; means I've to
omit
off days (Friday & Saturday)

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

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_rang e)


This requires the Analysis Toolpak to be installed.

--
HTH

Bob Phillips

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

"faisalm" wrote in message
...
I've to count total number working days from a range date; means I've to
omit
off days (Friday & Saturday)