DateText

 

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.

 

Parameters: 
 

1.Date - Excel date

 

Examples:

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