Day of the Year in Microsoft Excel

In this article, we will learn how to calculate the day of the year today. We use the Date function and will return the today date in Microsoft Excel 2010.

We will use the Date function to calculate the date as days and for today date we can use Today function or we can use the today date shortcut. Before learning how we can return the today what day of the year, we will understand the Date Function.

Date: - Returns the number that represents the date in Microsoft Excel date-time code.

The Syntax of Date:- =Date (year, month, date)

For Example:- Year in cell A2, month in cell B2 and date in cell C2.

  • Write the formula in cell D2 =DATE(A2,B2,C2).
  • Press Enter on your keyboard.
  • The function will convert it into date.

img1

 

To return the day of the year, follow below given steps:-

  • Select the cell A1.
  • Press the key Ctrl+; then press Enter on your keyboard.
  • Today date will show.

img2

 

  • Write the formula in cell B1.
  • =A1-DATE(YEAR(A1),1,1)+1
  • Press Enter on your keyboard.
  • The function will return the day of the year.

img3

 

This is the way we can return that today what day of the year in Microsoft Excel.

image 4

 

 

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube