Microsoft excel formula day of week

Didn't match my screen. Incorrect instructions. Too technical. Not enough information. Not enough pictures. Any additional feedback? Submit feedback. Thank you for your feedback! A Date. Description Result. Then right click and choose Format Cells from the context menu, see screenshot:. Then click OK button to close the dialog, and you will get the following results:. If you have Kutoools for Excel , with its Apply Date Formatting utility, you can also convert the date to day name, moth name, year name or other date formatting as you like.

Select the date cells that you want to get the day of week name. In the Apply Date Formatting dialog box, choose Wed or Wednesday from the Date formatting list box, and you can preview the results from the Preview pane, see screenshot:. Then click Ok or Apply button, all the selected date have been replaced by the day name that you want. To know more about this Apply Date Formatting utility.

Free Download Kutools for Excel Now. Note: The other languages of the website are Google-translated. Back to English. Log in. Remember Me Forgot your password? Password Reset. How do I filter out the data in all Weekends in Excel.

How to filter out all data in all weekdays This post will guide you how to determine if a date falls on the weekend in Excel. How do I check if a date falls on the weekend with a formula in Excel. How to check if a date is This post will guide you how to count the number of weekends between two dates in Excel. How do I get the number of weekends between 2 dates with a formula in Excel.

How to count weekend days between dates This post will guide you how to convert a week number to a date with a formula in Excel. How do I calculate a date from a week number and a year with formula in Excel. Or how to get This post will guide you how to get the first Monday of a given year or date in excel.

How do I calculate the first Monday of a specific year in excel.