Posted to microsoft.public.excel.worksheet.functions

Claus Busch Claus Busch is offline

external usenet poster

Posts: 3,872

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculate pay periods between two dates if paid on 1st and 15th?	janplan	Excel Discussion (Misc queries)	2	August 13th 08 03:48 AM
calculate remaining pay periods	maijiuli	Excel Worksheet Functions	5	January 24th 08 10:32 PM
HOW to calculate the interest paid between 2 custom periods?	TiDz	Excel Worksheet Functions	1	June 30th 06 12:46 PM
calculate time periods	umba-sr	Excel Worksheet Functions	1	February 21st 06 02:13 PM
How do I calculate rate when pmt is made at end of periods	hsummer	Excel Worksheet Functions	1	August 7th 05 10:29 PM

All times are GMT +1. The time now is 07:03 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us