Works 95: Calculated Payment Date in TaskWizard May Be Incorrect
Article ID: 151730
Article Last Modified on 11/15/2004
APPLIES TO
- Microsoft Works 4.5 Standard Edition
- Microsoft Works 4.0 Standard Edition
- Microsoft Works 4.0a
This article was previously published under Q151730
SYMPTOMS
The Mortgage and Loan Analysis TaskWizard contains a formula that may
calculate payment dates incorrectly.
RESOLUTION
If the start date in cell H7 is greater than 28, the calculated payment
date is not correct. The formula in cell B19 must be modified to calculate payment dates correctly.
Correct the formula by typing the following line in the
Entry Bar or cell
B19:
=IF(B18,DATE(YEAR(B18),MONTH(B18)+1,IF(DAY(B18)>DAY(DATE(YEAR(B18),MONTH
(B18)+2,1)-1),DAY(DATE(YEAR(B18),MONTH(B18)+2,1)-1),DAY(H$7))),"")
: You may need to be fill down from cell B19, depending on how many payments are made.
STATUS
This problem is corrected in Works version 4.0a.
Additional query words: 4.00 w_works wizard spreadsheet
Keywords: kbprb KB151730