Days into the year
Using the DATE function
By Neale Blackwood
Ever needed to find how may days have passed into a year? For any date in A1 this formula will tell you how many days have passed.
When you use the 0 on the end of a DATE function it calculates the last day of the previous month. If A1 contained 10/2/09 the formula would display 41.