Ever needed to find how may days have passed in a year? For any date in A1 this formula will tell you how many days have passed.
=A1-DATE(YEAR(A1),1,0)
If A1 contained 10/2/09, the formula would display 41.
When you use the 0 on the end of a DATE function it calculates the last day of the previous month.