Thread: Counting # of days between 2 dates excluding Fri & Sat)
View Single Post
  #18   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default Counting # of days between 2 dates excluding Fri & Sat)
Yet another one:

=SUM(INT((WEEKDAY(A1-{1,2,3,4,5})+B1-A1)/7))

Just don't ask me how it works!

--
Biff
Microsoft Excel MVP


"Bernd P" wrote in message
...
Hello,

Yet another one:
=B1-A1+1-INT((B1-MOD(B1-6,7)-A1+7)/7)-INT((B1-MOD(B1-7,7)-A1+7)/7)
Non-volatile and non-matrix.

Regards,
Bernd


Reply With QuoteReply With Quote