Bi-Weekly

D

Debbie

Is there a way to setup a payment schedule in excel that will automatically
update to reflect a bi-weekly deduction?

Thanks!
 
T

Trevor

=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.
 
Top