View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Infinitogool Infinitogool is offline
external usenet poster
 
Posts: 52
Default Counting number of pay period dates between 2 numbers

Hi janplan
1 day A1
2 day B1
Try
=SUMPRODUCT((DAY(ROW(INDIRECT($A$1&":"&$B$1)))=1)+ (DAY(ROW(INDIRECT($A$1&":"&$B$1)))=15))

Regards,
Pedro J.


If I have two dates (i.e. hire and terminated dates), how do I calculate the
number of pay periods if the person was paid the 1st and 15th of every month?