Home > Article > Software Tutorial > 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!