To deal with date-related calculations in Google Sheets, you need to be familiar with the available date functions. Google Sheets offers a range of date functions to simplify your calculations. In this article, we will explore how to find the total number of working and non-working days in Google Sheets.
If you’re new to date functions in Google Sheets, it’s a good idea to refer to the comprehensive tutorial on Google Sheets Date Functions at a Glance. This guide will help you get up to speed with all the date functions available in Google Sheets.
Now, let’s dive into finding the total number of working and non-working days in Google Sheets.
How to Find the Total Number of Working and Non-Working Days in Google Sheets
The NETWORKDAY function is the key to finding the working days between two given dates in Google Sheets. However, what about the non-working days? In this tutorial, we’ll provide you with a flexible solution to find both the number of working and non-working days starting from a single date.
To find the working days in the current month from today’s date, you can use the following formula:
=NETWORKDAYS(eomonth(today(),-1)+1,eomonth(today(),0))This formula calculates the total number of working days in the current month. If you want to find the working days in a specific month, simply replace today() with the date of your choice. For example, to find the working days in June 2018, use the following formula:
=NETWORKDAYS(eomonth("22/06/2018",-1)+1,eomonth("22/06/2018",0))The magic lies in the EOMONTH function, which allows us to find the end of the month date. By adding one to the end of the previous month’s date, we can find the starting date of the current month or any provided date’s month.
But what about the non-working days? Once we have the total number of working days, all we need to do is subtract this number from the end of the day of the current month. The result will be the total number of non-working days.
To calculate the total number of non-working days in the current month, use the following formula:
=day(eomonth(today(),0))-NETWORKDAYS(eomonth(today(),-1)+1,eomonth(today(),0))This formula returns the total days in the current month and subtracts the total number of working days calculated using the previous formula. You can replace today() with any custom date to find the number of working and non-working days for that specific month.
That’s all there is to it! With these formulas, you can easily find the number of working and non-working days in Google Sheets.
Stay tuned for more helpful Google Sheets formulas and tutorials on Crawlan.com.
