Day of week for date in Excel

For example, the day of the week of 01st Jul 2017.

To do it in Excel, here is the answer:

a) Enter the formula =TEXT(AG2,"dddd") where AG2 contains the date for which day of the week is to be determined.

excel day of week for date


You can find similar Excel Questions and Answer hereunder

1) How to do date and time zone conversion in excel in Excel

2) Sumifs with date range as criteria in Excel

3) How can I have text autocomplete by typing in a short code for the text?

4) How can I get the day number of the year for a date - for example 5 for Jan 5, 33 for Feb 2?

5) How do I get the principal part of loan payment for a period given Loan amount, Rate of Interest and period?

6) I conducted a test and the test scores are available - how can I get Percentile rank of students?

7) How can I add interval to dates?

8) Can I add a Text histogram to Table data to make it visually appealing and easy to interpret?

9) I have to determine bonus for my staff based on ratings (for each rating, specific bonus amount). In Excel, how can I set up my Bonus Table?

10) How can I clear cell after activating a routine when there is a change in value of a cell?


Here the previous and next chapter