Using Weekday function in Excel

=Weekday(now())
The above formula will display the current day of the week. For example, if you entered this formula in a cell within excel on a Monday. Then the formula will display the word "Monday".

Read More..