How to extract date from text in excel

1. Select a cell, click [Formula], then [Insert Function] option;

2. Select [ TEXT] function, click [OK];

##3. Select the target area (the cell where the text date is located) and set the numerical format to [yyyy/m/d], such as [TEXT(A2,"yyyy/m/dd")], click [OK].

Recommended tutorial:

excel tutorial

The above is the detailed content of How to extract date from text in excel. For more information, please follow other related articles on the PHP Chinese website!