TextDate

 

Syntax: TextDate(Date)

 

Equivalent Function Names: TD

 

Purpose: Converts the Excel date, even before 1900 which Excel is unable to handle natively, of the format yyyy-MM-dd to an Excel Date

 

Parameters: 
 

1.Date - Excel date in a string yyyy-MM-dd format

 

Examples:

1. Convert post-1900 yyyy-MM-dd string to a date

Use =TD(C31873) to convert a date specified as a yyyy-MM-dd string to an Excel Date

 

 

2. Convert pre-1900 yyyy-MM-dd string to a date

Use =TD(C2) to convert a date specified as a yyyy-MM-dd string to an Excel Date

 

 

 

Copyright © 2013-2017 Jiri Pik

Document Version: Sunday, May 7, 2017