Bi-Weekly

  • Thread starter Thread starter Debbie
  • Start date Start date
D

Debbie

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

Thanks!
 
It has a deduct amount in column a and the date starting 8/6/04 in column b.
 
=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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Schedule bi-weekly payments? 4
Bi-weekly mortage payments 3
Current bi-weekly total 2
Business forcasting help... 1
How do I schedule bi-weekly meetings with Outlook? 2
Schedule recurrence for bi-weekly 4
Use the Loan Template to calculate bi-weeky payments 1
How do I clear 'form' content from an unprotected cell without mac 4

Back
Top