Or, you could just count all the days that *aren't* Sundays then subtract 1:

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)),2)<7))-1

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
One way:

A1 = start date
A2 = end date

=A2-A1-SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))=1))

--
Biff
Microsoft Excel MVP


"gwatt" wrote in message
...
Using Excel, need to calculate the difference between two dates,
excluding
Sundays .