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.