Works 95: Calculated Payment Date in TaskWizard May Be Incorrect (151730)


The information in this article applies to:

  • Microsoft Works 4.5
  • Microsoft Works for Windows 95, version 4.0
  • Microsoft Works for Windows 95, version 4.0 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))),"")

NOTE: 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.
Modification Type:MajorLast Reviewed:11/15/2004
Keywords:kbprb KB151730
©2004 Microsoft Corporation. All rights reserved.