Equivalent Function Names: DT
Purpose: Converts the Excel date, even before 1900 which Excel is unable to handle natively, to a text string of the format yyyy-MM-dd which is possible to sort as a text.
1.Date - Excel date
1. Convert post-1900 date to a string
2. Convert pre-1900 date to a string
Quandl returns DJIA values since 1896, to make sense of the dates, use the formula =DT(A2)
Copyright © 2013-2017 Jiri Pik
Document Version: Sunday, May 7, 2017