The WEEKDAY function accepts a date argument and returns an integer between 1 and 7 that corresponds to the day of the week. The following formula, for example, returns 3 because the first day of the year 2008 falls on a Tuesday:

=WEEKDAY(DATE(2008,1,1))

The WEEKDAY function uses an optional second argument that specifies the day numbering system for the result. If you specify 2 as the second argument, the function returns 1 for Monday, 2 for Tuesday, and so on. If you specify 3 as the second argument, the function returns 0 for Monday, 1 for Tuesday, and so on.

You can also determine the day of the week for a cell that contains a date by applying a custom number format. A cell that uses the following custom number format displays the day of the week, spelled out:

dddd

• How to Stay Focused With Multiple Streams of Income One of the main problems facing those that have multiple streams of income is managing them. You can start to...
• Use Correlation Test of MS Excel Data Analysis of Excel has a function to determine the relationship between two variables.  Result of this function is coefficient...
• Fun with sed --- Date format conversion between Excel and SQL [Updated March 9, 2009: Added the code listing to show how the regular expression is used.] Here is a little...
• Fishing Report: October 23, 2009 Lake Fishing - At Amador, a 3,000 lb trout plant just went in, some of which were as large as...
• All signs are pointing toward an exciting US Open tournament. The summer of contentment surrounding Roger Federer has shown absolutely no signs of abatement today, as this brand new father...