day_in_week(date)

Returns an integer representing the day of the week for a specific date. 1 = Sunday, 2 = Monday and so on.