Mega Code Archive
Categories
/
MSOfficeExcel 2007 Tutorial
/
Date Time Functions
To enter New Years Day for a specific year in cell A1
Input the formula: =DATE(A1,1,1)