Microsoft KB Archive/151730

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

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.

Additional query words: 4.00 w_works wizard spreadsheet

Keywords: kbprb KB151730

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.