View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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 .