Thread: Calculate the number of pay periods in a given span
View Single Post
  #3   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 again,

Am Thu, 29 Aug 2019 03:22:24 +0200 schrieb Claus Busch:

=(MOD(D4-7-1,7)+E4-D4-2)/14

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


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