Date Time Functions MSOfficeExcel 2007 Tutorial

Input the formula: =DATE(YEAR(A1),12,31)-A1