- Trending Categories
- 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.