The WEEKDAY function returns 1 for Sunday, 2 for Monday, 3 for Tuesday, 4 for Wednesday, 5 for Thursday, 6 for Friday, and 7 for Saturday. September 30, 2009 was a Wednesday, so WEEKDAY(TODAY()) returns 4. Note that WEEKDAY uses Sunday as day 1, not Monday.