Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date/If function for past dues
I want to be able to put in a formula that will tell me if a loan recipient's
loan is past due. Column A is payment due date Column B is payment amount due Column D is acutal date payment is rec'd Column E is actual amount received Any help that anyone can offer will be appreciated, including a formula that will work or a different way to set up my workbook to give me what I want. (Essentially, I have a page for each borrower and a summary sheet on the front page that shows original loan balance, balance due, late payments, etc.) Thank you, Tara |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |