Determining the day of the week
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
// Related Posted - GOOGLE!
Related Websites
- Good Debt, Bad Debt and Flawed Investment Return Data I can't tell you how often I hear or read someone argue that they have "good debt." This "good debt" ...
- Credit Card Research: Escape by Discover Card. Since I get emails all the time asking about different credit cards and if people should be signing up for...
- OnPar Golf Touchscreen GPS User Reviews Send this to a friend OnPar Golf Touchscreen GPS Manufacturer: OnPar Customer Rating: List Price: $479.95 Sale Price:...
- 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...
- Is this a good time to prepay our mortgage? You know how I feel about debt, including mortgage debt. As a matter of fact, just last week I posted...
