Thread: Formula to get number of days excluding Fridays in a given period
View Single Post
  #18   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default Formula to get number of days excluding Fridays in a given period
Hello,

Passed:
=E4-D1+1-SUM(INT((E4-MOD(E4-{5,6},7)-D1+7)/7))

Remaining:
=C1-E4-SUM(INT((C1-MOD(C1-{5,6},7)-E4+6)/7))

Source:
http://sulprobil.com/html/date_formulas.html

Actually, it seems to be the same as MRT's - just WEEKDAYS replaced by
MOD...

Regards,
Bernd
Reply With QuoteReply With Quote