Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Date Time Functions

 

=DATE(2001, 15, 2) returns March 2, 2002, because March 2002 is 15 months after the first month of 2001

Input the formula: =DATE(2001, 15, 2)