View Single Post
  #3   Report Post  
Myrna Larson
 
Posts: n/a
Default

Sorry, but that's not a option. The function was not written to handle that
problem. If your problem is that your weekend days are not Saturday and
Sunday, but (for example) Friday and Saturday, you can write the formula as

=NETWORKDAYS(A1+1,B1+1,HolidayList)

where A1 and B1 contain the starting and ending dates, and the dates in the
holiday list have all been incremented by 1 as well.

If that's not it, you would need to write a VBA function of your own. If you
can describe your problem more fully, including what the extra argument means,
perhaps we can help.

On Sat, 22 Jan 2005 07:45:02 -0800, rkk wrote:

I need one more argument in Networkdays function after Startdate and Enddate,
weekend day or days in form of 1,2,3,4,5,6,7 before holdays

Any solution

Thanx