Hunting Excel date twins

Posted by Bob_Mesibov on Mar 8, 2021 5:04 PM EDT
BASHing data		Mail this story
Print this story

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.

Full Story

  Nav
» Read more about: Story Type: Tutorial; Groups: Linux

« Return to the newswire homepage

This topic does not have any threads posted yet!

You cannot post until you login.