Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Date Time Functions

 

=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)