Date Time Functions MSOfficeExcel 2007 Tutorial

  1. Home
  2. MSOfficeExcel 2007 Tutorial
  3. Date Time Functions
  4. =DATE(2006, -5, 16) returns the date July 16, 2005 because July 2005 is 5 months before the first month of 2006
Input the formula: =DATE(2006, -5, 16)