Mailing the story:

Hunting Excel date twins

  • BASHing data (Posted by on CST)
  • Story Type: Tutorial; Groups: Linux
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.
What is your name?

What is your E-Mail address?

What is the email address of the recipient?

Add a special note from yourself?