Thread: Calculate the number of pay periods in a given span
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Calculate the number of pay periods in a given span
Hi,

Am Thu, 29 Aug 2019 03:27:16 +0200 schrieb Claus Busch:

sorry, typo.
Try:
=(MOD(D4-1-1,7)+E4-D4-2)/14

or try:
=SUMPRODUCT((WEEKDAY(ROW(INDIRECT(D4&":"&E4)),2)=7 )*1)/2


Regards
Claus B.
--
Windows10
Office 2016
Reply With QuoteReply With Quote