DAYOFYEAR(<date>)
Returns the day of the year for the supplied date in a range from 1 to 366.
Jan 1, 2018 12:23:05 PM
Jun 14, 2018 12:23:05 PM
Dec 25, 2018 12:23:05 PM