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.

=A1-DATE(YEAR(A1),1,0)

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.