How to use text function to convert date format in excel

Conversion method: 1. Use the "TEXT(specified cell, "yyyy-mm-dd")" statement to modify the date format to "yyyy-mm-dd"; 2. Use "TEXT((specified cell Format, "yyyy year mm month dd day")" statement changes the date format to "yyyy year mm month dd day".

1. Modify the date format to yyyy-mm-dd

=TEXT(A2,"yyyy-mm-dd")

2. Modify the date format to yyyy year mm month dd day

=TEXT(A2,"yyyy年mm月dd日")

excel tutorial

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