Return the number of days remaining in the year from a particular date : YEAR « Date Time functions « Microsoft Office Excel 2007 Tutorial






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








15.18.YEAR
15.18.1.YEAR() returns the yearYEAR() returns the year
15.18.2.=YEAR("7/5/10")=YEAR(
15.18.3.Return the day of the year for a date stored in cell A1:Return the day of the year for a date stored in cell A1:
15.18.4.Return the number of days remaining in the year from a particular dateReturn the number of days remaining in the year from a particular date
15.18.5.calculates the number of years between two dates.calculates the number of years between two dates.