How do I work with Dates before 1900?

 

Some data sources, such as Quandl.com, provide data as of pre-20th century which is causing Excel problems as Excel understands dates as of Jan 1, 1900. To work effectively with such dates, use the Spearian's functions DateText and TextDate.

 

 

Copyright © 2013-2017 Jiri Pik

Document Version: Sunday, May 7, 2017