When processing WPS** data, we may need to use a function that can return the number of weeks, so let's take a look at the specific example.
Select cell b2 of the worksheet below, and enter the formula: =text(a2,) in English"aaaa"), press enter to confirm the formula, which can return the Chinese week corresponding to the date in cell A2.
Formula description: The text function is a format conversion function, the first parameter a2 is the object to be converted, the second parameter is the converted display format, [aaaa] is the format corresponding to the Chinese week**.
We can select the A2 cell, and press Ctrl+1 to open the [Cell Format] dialog box, customize the [Type] format to [AAAA] for verification, and in the [Example] area, you can preview the display effect of the corresponding format**, which is consistent with the result we return with the function.
Finally, fill the formula in cell B2 downward.
Select cell B2 and enter the formula: =text(A2,"dddd"), press enter to confirm the formula, and you can return the English week of the week corresponding to the date in cell A2.
Formula description: The first parameter a2 of the text function is the object to be converted, and the second parameter [dddd] is the format corresponding to the English week**.
Next, fill the formula in cell B2 downward.
Select cell B2, enter the formula: =weekday(A2,2), press enter to confirm the formula, and return the day of the week number corresponding to the date in cell A2.
Formula description: The weekday function is used to return the day of the week for a certain date, and the returned result is a number. The first parameter a2 is the date on which the number of the week to be returned, and the second parameter 2 is the return value type. If the return value type is 2, the number of weeks returned from Monday to Sunday is 1 to 7.
Finally, fill the formula in cell B2 down to return the day digits corresponding to all dates.
Hardware model: ASUS Vivobook 16; Software version: Windows11; App version: WPS 121.0.16388
This article was originally written by Jingxin Office, welcome to pay attention! For more practical tips on office software, welcome to learn on your personal homepage! Controversy Project
Previous recommendation: How to lock the font size in word? Set the font size to default and you're good to go! Word Practical Office Tips: How to Make a Cell Only Fill with a Few Options? WPS function comprehensive application case: Quickly determine gender and gender in batches based on ID numbers.