Calculate Day of Year and Days Remaining in Excel

How to Calculate the day of the year and the days remaining in Excel

Day of the year:
=A1-DATE(YEAR(A1),1,0)

Remaining days:
=DATE(YEAR(A1),12,31)-A1

Thanks to:Spreadsheet Page Excel Tips: Calculate The Day Of The Year And Days Remaining