First select the date
then right-click and select Format Cells
Select the date format in the pop-up dialog box
Then select Custom, yyyy year m month d day appears: @Format
Change the format to yyyy year mm month dd day aaaa, and then click Confirm
The effect is as follows:
Recommended tutorial: excel tutorial
The above is the detailed content of How to generate weekday corresponding to date in excel. For more information, please follow other related articles on the PHP Chinese website!