Hi,

You can do it with Sumproduct and weekday which isn't part of ATP like this

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)),2)<6))

and if you want to include holidays try this

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)),2)<6),--(ISNA(MATCH(ROW(INDIRECT(A1&":"&B1)),C1:C8,0))))

Where your holidays are in c1 - c8

Mike

"Darrell_Sarrasin via OfficeKB.com" wrote:

I need a way of counting workdays between two dates. i can do it using the
NETWORKDAYS function but I know that not everyone has the add ons turned on
so its pointless as 100 people will be viewing this.

Any Help is greatly appreciated.

--
Message posted via http://www.officekb.com