How to calculate the day of the week for a certain date in Excel. Tutorial method for quickly calculating the day of the week for a certain date in Excel.

When we use Excel, we sometimes need to calculate the day of the week for a certain date, so how to calculate it quickly? Below I will share the method tutorial with you. If you need it, you can learn more. How to calculate what day of the week a certain date is in Excel? Tutorial method to quickly calculate the day of the week for a certain date in Excel

First open a table with dates:

Select cell B2, click the [Formula] option on the toolbar, and select [Insert Function] in the drop-down menu ]:

In the pop-up Insert Function dialog box, select "Date and Practice", select "WEEKDAY" in the function column, and click OK:

In the pop-up function parameter dialog box, enter " A2", enter "2" in the second column, click OK:

Finally, when we complete the filling, we will find that the day of the week appears in all cells:

The above is the detailed content of How to calculate the day of the week for a certain date in Excel. Tutorial method for quickly calculating the day of the week for a certain date in Excel.. For more information, please follow other related articles on the PHP Chinese website!