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

Report Scraped Content to Google - New Form!

If you find your work has been scraped, you can report it to google with Google's new Scraper Report form:

https://docs.google.com/forms/d/1Pw1KVOVRyr4a7ezj_6SHghnX1Y6bp1SOVmy60QjkF0Y/viewform

This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.