Return the day of the year for a date stored in cell A1: : YEAR « Date Time functions « Microsoft Office Excel 2007 Tutorial

1. Microsoft Office Excel 2007 Tutorial
2. Date Time functions
3. YEAR

=A1-DATE(YEAR(A1),1,0)

15.18.YEAR
	15.18.1.	YEAR() returns the year
	15.18.2.	=YEAR("7/5/10")
	15.18.3.	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 date
	15.18.5.	calculates the number of years between two dates.