Thanks Ron,

Yes it is. I think I can see what it's doing

Ron Coderre wrote:
To count the number of workdays lost...try one of these:

For
A1: (startdate)
B1: (enddate)

This one requires the Analysis ToolPak add-in to be enabled:
C1: =NETWORKDAYS(A1,B1)

Note: there is a 3rd argument in the NETWORKDAYS function for a list of
holidays that you don't want to count as missed workdays. See Excel Help for
more information.

OR
This function does not requer the Analysis ToolPak add-in:
C1: =SUMPRODUCT(--(WEEKDAY(ROW(INDEX(A:A,A1):INDEX(A:A,B1)),2)<6))

Change the range references to suit your situation.

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP

Hi Ron,

[quoted text clipped - 39 lines]

;)

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