Works 95: Calculated Payment Date in TaskWizard May Be Incorrect

Retired KB Content Disclaimer

View products that this article applies to.

This article was previously published under Q151730

Expand all | Collapse all

SYMPTOMS

The Mortgage and Loan Analysis TaskWizard contains a formula that may calculate payment dates incorrectly.

Back to the top

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))),"")

NOTE: You may need to be fill down from cell B19, depending on how many payments are made.

Back to the top

STATUS

This problem is corrected in Works version 4.0a.

Back to the top

APPLIES TO

Microsoft Works 4.5 Standard Edition
Microsoft Works 4.0 Standard Edition
Microsoft Works 4.0a

Back to the top

kbprb KB151730

Back to the top

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top