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 days left in a month or year in Excel?
At times, you may want to know the working days left in a month or in a year. So, if you want to calculate the remaining days left in a month or to calculate the remaining days left in a year you can follow the below article which is easy and quick to calculate the days left in a month or in a year in an Excel sheet.
Follow the steps given below to calculate the days or working days left in a month.
Step 1
Open an Excel sheet and enter the date for which you want to calculate the remaining days or working days left in that specific month as shown in the below screenshot for your reference.
Step 2
Now you need to enter the below given formula and press enter key to calculate the days remaining or left in a specific month. Kindly find the below screenshot for your reference.
=EOMONTH(A2,0)-A2
Step 3
If you see in the above screenshot days left in a month have been captured as a date. You need to change the format to general. To do this select the cell, and then you need to right click to choose format cells from the format cell dialog box and then click on general from the left category under the number tab as shown in the below screenshot for your reference.
Step 4
Now you need to click on ok to see the remaining number of days left in a specific month given as shown in the below screenshot for your reference
Note − If you want to calculate only the working days left in a month then you need to use the formula =NETWORKDAY(A2,EOMONTH(A2,)) and then press enter key.
If you want to calculate the days left in a year for a given specific date, you need to use the below given formula. Enter the formula given below into the blank cell and then press enter key as shown in the below screenshot for your reference.
=DATE(YEAR(A2),12,31)-A2
Conclusion
In this tutorial, we used a simple example to demonstrate how you can calculate the days left in a month or year in Excel.
4K+ Views
