past due

Hello everyone, I work for an accounting department at a large resort chain. We have to perform quarterly audits on the cash banks issued to select employees around the property. Right now I have a master sheet that has every employee with a bank and the date that bank was issued in a left...

I have a sheet that I am trying to calculate days past due. I=Date Due J=Days Past Due K = Date Implemented I want to calculate the days past due, stopping counting once the date implemented is entered and I need to ignore blank cells. I have a formula that works to stop counting after the...

Hi all, I need some help creating a formula that will highlight a cell if the cell begins with the letter F and not A. I would like to be able to highlight past due cells as well as highlight those coming up within 2 weeks. I have half the equation but ma having some trouble on the second...

have a situation I'm not sure if you can help. I'm trying to calculate total months past due and total due based on a monthly payment schedule. I'm a small business owner trying to save a few bucks rather than buying an expensive softwares I know access can do this for me. I need a formula based...

I am trying to determine the amount of finance charges due based on 18% APR when I have the payment terms in one column (ie Net 15), the invoice date in one column (ie 1/15/12), the balance due in a column (ie $790.00), and the statement date in a column (ie 5/18/12). Suggestions? Also, to add...