Mega Code Archive
Categories
/
MSOfficeExcel 2007 Tutorial
/
Date Time Functions
Return the day of the year for a date stored in cell A1
=A1-DATE(YEAR(A1),1,0)