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
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
and similar in D2
Then in F2
[HtmlMaker 2.41] To see the formula in the cells just click on the cells hyperlink or click the Name box