January 1 is the first day of the year, and December 31 is the last day. But what about all those days in between? The following formula returns the day of the year for a date stored in cell A1:

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

The following formula returns the number of days remaining in the year after a particular date (assumed to be in cell A1):

=DATE(YEAR(A1),12,31)-A1

When you enter either of these formulas, Excel applies date formatting to the cell. You need to apply a nondate number format to view the result as a number.

To convert a particular day of the year (for example, the ninetieth day of the year) to an actual date in a specified year, use the formula that follows. This formula assumes that the year is stored in cell A1 and the day of the year is stored in cell B1:

=DATE(A1,1,B1)

• Excel Tip: Have Your Cell Contents = Tab Names It's time for another edition of Stupid Excel Tricks! One of my coworkers recently asked me an Excel question.  He...
• Save Time, Money and Space in Over 80 Ways If you're looking for handy gadgets, tools and various items that can save you time, money or space (or all...
• USA - MS: Autologous Stem Cell Transplants, Visible Progress in 8 of 10 Patients Image via Wikipedia Transplanting stem cells from one’s own bone marrow (autologous stem cell transplants) improves the symptoms of muscular...
• Tips On Returning Gifts After Christmas Now that Christmas has come and gone and the week long Boxing Day sales are over, you may have some...
• Employee and Student Cell Phone Discounts Available at Verizon, AT&T, T-Mobile and Sprint My wife and I don't ever plan on having a land line phone. It really isn't worth it considering we...