How to calculate the difference between two dates, excluding Sund.
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 .
|