Basically, every database needs to have a Dates table. It has so many business applications and solves so many problems, that you don't want to calculate things when you can have them pre-calculated already.
BTW, that particular article was recommended by a great SQL Server MVP in this thread