You are not counting ONLY full pay periods.

That's correct, I was only counting pay dates.

Biff

"Ron Rosenfeld" wrote in message
...
On Mon, 13 Jun 2005 23:03:50 -0400, "Biff" wrote:

Hi!

Try this.

A1 = start date
B1 = end date

Requires the Analysis ToolPak add-in be installed.

=SUMPRODUCT(--(DAY(ROW(INDIRECT(A1&":"&B1)))=15))*2+OR(B1=EOMONT H(B1,0),DAY(B1)<15)-(DAY(A1)<=15)


You are not counting ONLY full pay periods.

For example:

StartDate = 1/13/2005
End Date = 3/18/2005

Your formula(s) -- 5

Full Periods:

1/16 - 1/31
2/1 - 2/15
2/16 - 2/28
3/1 - 3/15


--ron