Ok, I have a field that needs to calculate the dollar amount entered (I12) divided by the number of pay periods left in the year. The number of pay periods would have to be determined by the date eligible. The date eligible would be 30 days following the hire date (F12) For instance, someone is hired on 8/18/06 his eligible date would be 9/18/06, the next payroll date is 9/29/06 which is week 20 and leaves 7 pay periods left for the year. If they elect 2,000.00 for the year then the deduction per pay period would be $285.71. The other problem I run into is that every year the payroll weeks will change. So next year week 20 will be 9/28/07.

Anyone? :( Please?

On Thu, 31 Aug 2006 17:10:25 +0100, Seti
wrote:


here is the formula =ROUNDDOWN((A2-G7)/365.25,0)
A2 should never change, yet when i try to copy and past it will go to
A3 A4 etc. Whats the problem?

Thanks!

Change the A2 reference to be absolute. i.e.

=ROUNDDOWN(($A$2-G7)/365.25,0)

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

Thanks! do you happen to have any knowledge on my other problem?