Excel Hacks, Second Edition Tips & Tools for Streamlining Your Spreadsheets
by David Hawley, Raina Hawley

The unconfirmed error reports are from readers.  They have not yet been 
approved or disproved by the author or editor and represent solely the
opinion of the reader.

Here's a key to the markup:
        [page-number]: serious technical mistake
        {page-number}: minor technical mistake
        <page-number>: important language/formatting problem
        (page-number): language change or minor formatting problem
        ?page-number?: reader question or request for clarification

This page was updated April 14, 2008.


UNCONFIRMED  errors and comments from readers: 

[202] Figure 6-6. Date formats converted to valid dates (U.S. format);
1. Formula used in column B cannot possibly give the correct New Dates in column C;
2. In fact, the formula used will only give #VALUE errors.
3. Moreover, the formula used are identical to those in Figure 6-7. Date formats converted to valid dates 
(European format)- and that's why they are wrong!

The question that begs to be answered, then, is: How can the formula used in column B produced the dates 
shown in New Date column C in a SCREEN SHOT of the worksheet?


(207) in the tip paragraph;
The tip refers back to hack 78 (a date hack) when it should point to hack 79 (DSUM hack) instead.