Hello dr427,

When exactly are the pay periods, you didn't say?

Shouldn't all the dates in A2:A8 be between 1st July 2009 and 30th June 2010?

Perhaps it would be simple to just list all the pay dates. I put the first pay date in J2 and then used this formula in J3

=J2+14

to get the next pay date.....and then copied this down to J27 to get all pay dates in the year. For next year you can just change the date in J2 to get all the dates....

Then in B2 you can use this formula copied down

=COUNTIF(J$2:J$27,"<"&A2)

and similar in D2

=COUNTIF(J$2:J$27,">="&A2)

Then in F2

=(B2*C2+D2*E2)*112

see below

[HtmlMaker 2.41] To see the formula in the cells just click on the cells hyperlink or click the Name box

PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.