dayOfWk(year,month,day) returns an integer from 1 to 7, each representing a separate day of the week. 1 represents Sunday, 2 represents Monday, and so on, until 7 goes with Saturday. The date format is different than the normal American format (month/day/year), so be careful to put the arguments in the right order.
The above code returns 1, because the 30th of December, 2007, is a Sunday.
- ERR:DOMAIN is thrown if any of the arguments are non-integral, or the date does not exist, such as the 42nd of February. However, the year does not matter (a date that takes place in the year 10000 is valid). However, there are exceptions, even if some dates do exist, this error may still occur. If you attempt to calculate the previous day of week such as the previous day, the error may still occur.
- Day of Week — routine to calculate the day of the week