![Trending Articles on Technical and Non Technical topics](/images/trending_categories.jpeg)
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to calculate / get day of the year in Excel?
Did you ever attempted to determine in Excel which day of the year a particular date falls on based on the 365 days in a year? For instance, the current date is 22-08-2022, and I need to find out which day of the year today is based on the 365 days that make up a year. In this tutorial, I will discuss a straightforward method that may be used to deal with it.
You can solve this problem by using a straightforward formula. We do not have a direct function that allows us to determine the precise day of a year; nevertheless, you can use this formula.
Let’s understand step by step with an example.
Step 1
In the first step, Let’s assume we have a sample data for calculate or get day of the year. Please refer to the screenshot below.
![](https://www.tutorialspoint.com/assets/questions/media/526132-1675319884.jpg)
Step 2
We have a list of dates in cell A2:A10. Now, you want to calculate the day of the year. Then, entered this formula into a blank cell in column B. Please check out the screenshot below for the same.
Formula
=A2-DATE(YEAR(A2),1,0)
![](https://www.tutorialspoint.com/assets/questions/media/526132-1675319981.jpg)
Important Note − A2 already contains the date you wish to use to determine the day of the year, but you can modify it as necessary.
Step 3
Then, the day of the specified date within the year will be displayed when you press the Enter key. Please Check out the screenshot below for the same.
![](https://www.tutorialspoint.com/assets/questions/media/526132-1675320035.jpg)
The day of the year can also be calculated using the following formula −
=A2-DATE(YEAR(A1),1,1)
Conclusion
In this tutorial, we used a simple example to help you understand how to calculate or get day of the year by using simple formula in Excel.