Syntax: DateText(Date)


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