D Debbie Jul 19, 2004 #1 Is there a way to setup a payment schedule in excel that will automatically update to reflect a bi-weekly deduction? Thanks!
Is there a way to setup a payment schedule in excel that will automatically update to reflect a bi-weekly deduction? Thanks!
D Debbie Jul 19, 2004 #3 It has a deduct amount in column a and the date starting 8/6/04 in column b.
T Trevor Jul 19, 2004 #4 =IF(CurrentDate>=$B$1,CurrentPay-$A$1,CurrentPay) where CurrentDate and CurrentPay are references to the proper columns, on the row in question, where those values are stored.
=IF(CurrentDate>=$B$1,CurrentPay-$A$1,CurrentPay) where CurrentDate and CurrentPay are references to the proper columns, on the row in question, where those values are stored.
