Linux

Hunting Excel date twins

Excel files can sometimes contain the same record with dates four years and one day apart. These pseudo-duplicates are the result of Microsoft’s choice of starting date for serial date numbers. The issue is explained in this post and I demonstrate one way to find Excel date pairs with command-line tools.

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Comment moderation is enabled. Your comment may take some time to appear.

Back to top button