Hi!

Business days = Mon thru FRI excluding holidays

Try one of these:

This first one requires that the Analysis ToolPak add-in
be installed:

=NETWORKDAYS(A1,B1,F1:F4)

F1:F4 is a list of holidays.

This one does not require the ATP:

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

Format cell as GENERAL.

Biff

-----Original Message-----
if I have a date in A1 and a Date in B1.....is there a
function or formula
for c1 that will tell me the number of business days
between the two dates?
thanks

A1 01/05/2005
B1 01/17/2007
C1 ????
.