How to calculate the day of the week for a certain date in Excel_How to quickly calculate the day of the week for a certain date in Excel

At work, we often encounter situations where we need to calculate the day of the week for a certain date. For this requirement, Excel provides a convenient method. PHP editor Zimo will introduce you in detail how to use Excel to quickly calculate the day of the week for a certain date to help you easily solve such problems.

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 function parameter dialog box that pops up, enter [A2] in the first column, enter [2] in the second column, and click OK:

Finally we complete the filling, it will Found that all cells have the day of the week:

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