Date Time Functions MSOfficeExcel 2007 Tutorial

  1. Home
  2. MSOfficeExcel 2007 Tutorial
  3. Date Time Functions
  4. Return the day of the year for a date stored in cell A1
=A1-DATE(YEAR(A1),1,0)