In certain cases, you may want to convert the weekday names to their corresponding numbers as following screenshot shown. How could you achieve it as quickly as possible in Excel worksheet?
To convert the weekday names to corresponding numbers, the following formula may do you a favor, please do as this:
Enter this formula into a blank cell where you want to return the result:
=MATCH(A2,{"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"},0), then drag the fill handle down to the cells that you want to apply this formula, and all the relative numbers based on the weekday strings have been populated into the cells, see screenshot:
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...