Works: Dates in Weekly Time Sheet Template Are Incorrect (233333)


The information in this article applies to:

  • Microsoft Works 4.5
  • Microsoft Works 4.5a
  • Microsoft Works for Windows 95, version 4.0
  • Microsoft Works for Windows 95, version 4.0 4.0a
This article was previously published under Q233333

SYMPTOMS

When you type a date in cell B8 of the Weekly Time Sheet template in Microsoft Works, the dates that are displayed in cells F11-H11 of the template are incorrect.

CAUSE

This behavior occurs because the formulas in cells F11-H11 are incorrect.

RESOLUTION

To resolve this issue, type the correct formulas in cells F11-H11. To do this:
  1. Start Microsoft Works.
  2. On the TaskWizards tab of the Works Task Launcher, click Business Management, click Employee Time Sheet, and then click OK.
  3. Click Yes, run the TaskWizard.
  4. Click Weekly Time Sheet, and then click Create It!
  5. On the Format menu, click Protection
  6. Under Protection, click to clear the Protect data check box, and then click OK.
  7. Type the correct formulas in the cells listed in the following table.

    CellCorrect formula
    F11=IF(B8,B8+3,"THUR")
    G11=IF(B8,B8+4,"FRI")
    H11=IF(B8,B8+5,"SAT")
  8. On the Format menu, click Protection
  9. Under Protection, click to select the Protect data check box, and then click OK.
  10. On the File menu, click Save As.
  11. In Save As dialog box, click Template.
  12. Type a name for the template, and then click OK.
To use the new template:
  1. Start Microsoft Works.
  2. On the TaskWizards tab of the Works Task Launcher, click User Defined Templates.
  3. In the list of user defined templates, click the template you named in step 12 earlier in this article, and then click OK.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type:MajorLast Reviewed:11/15/2004
Keywords:kbbug kbpending kbui KB233333
©2004 Microsoft Corporation. All rights reserved.