Dataproofer
Dataproofer copied to clipboard
Test: check for dates in 1900 or 1904
Please read how to create a new test if you're interested in writing this test.
For reasons beyond obscure, Excel's default date from which it counts all other dates is January 1st, 1900, unless you're using Excel on a Mac, in which case it's January 1st, 1904. There are a variety of ways in which data in Excel can be entered or calculated incorrectly and end up as one of these two dates. If you spot them in your data, it's probably an issue.