Lynn Pettis wrote a quick article on a bunch of useful date functions. It's here:
http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/