Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Date Time Functions

 

Return the number of days remaining in the year from a particular date

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