ParseDate

=ParseDate(string text; string format) : date

Results from function inside Excel


Purpose

Formula to convert text to date and time based on the ISO_8601 format.

Examples

=ParseDate("10.31.2019";"MM.dd.yyyy")  
=> 2019-10-31

=ParseDate("2019 jan 1";"yyyy MMM d")  
=> 2019-01-01

See

Related Functions


Get help with this function in the community →