How to generate weekday corresponding to date in excel

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!