How do I work with Dates before 1900?


Some data sources, such as, 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