83
edits
Excel Data Quality Toolkit: Difference between revisions
→Identified Date Earlier than Collected Date
Jegelewicz (talk | contribs) |
Jegelewicz (talk | contribs) |
||
| Line 53: | Line 53: | ||
=IF(A1<B1,"ERROR","OK") | =IF(A1<B1,"ERROR","OK") | ||
[https://github.com/Jegelewicz/data_quality/blob/main/Excel_examples/2024%20Excel%20data%20quality%20checks.xlsx Sample file] | |||
=== Year, Month, and Day Values Do Not Match Date === | === Year, Month, and Day Values Do Not Match Date === | ||