day of week for date in Excel

Q18. In Excel, how can I find the day of the week given a date?

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 can I add interval to dates?

2) Given a raw data Table, how can I find the value of a field for a specific value of another field?

3) Vba to return week numbers in Excel

4) Sumifs with date range as criteria in Excel

5) Keyboard shortcut for save as in Excel

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

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

8) Formula converts date to quarter and year in Excel

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

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

11) I am using Excel for Project Management - how can I find End Date for a task given Start Date and Task duration considering only working days?

12) 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?

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

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

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