Count of # of payroll periods between biweekly payroll dates

JENCOM

New Member
Joined
Sep 29, 2014
Messages
1
I am in the process of putting together an excel spreadsheet. I would like to automaticly have excel calculate the # of payrolls between biweekly payroll dates specifcly related to cross years.
For instance, we have 21 payrolls from 9/9/2014 - 6/30/2015, I would like the formula to return 21 payrolls. Also, if I change the date to reflect the next payroll 9/18/2014 - 6/30/2015, I woudl like the formula to return 20 payroll dates. . I would like to create a formula to count the number of payrolls. What formula should I be using?
Thanks
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

skywriter

Well-known Member
Joined
Feb 15, 2014
Messages
1,642
<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px" style="background-color: #DAE7F5" /><col /><col /><col /></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="text-align: right;;">9/9/2014</td><td style="text-align: right;;">6/30/2015</td><td style="text-align: right;;">21</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;">9/18/2014</td><td style="text-align: right;;">6/30/2015</td><td style="text-align: right;;">20</td></tr></tbody></table><p style="width:4.2em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #BBB;border-top:none;text-align: center;background-color: #DAE7F5;color: #161120">Sheet47</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #BBB"><thead><tr style=" background-color: #DAE7F5;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C1</th><td style="text-align:left">=INT(<font color="Blue">(<font color="Red">B1-A1</font>)/14</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C2</th><td style="text-align:left">=INT(<font color="Blue">(<font color="Red">B2-A2</font>)/14</font>)</td></tr></tbody></table></td></tr></table><br />
 

Watch MrExcel Video

Forum statistics

Threads
1,114,326
Messages
5,547,268
Members
410,783
Latest member
sonnny
Top