The number of working days left this month

I use this formula to show the number of days left this month. Is it possible to do this in the number of working days?

=EOMONTH(TODAY(),0)-TODAY() 
+4
source share
3 answers

The Analysis Tool also provides the NETWORKDAYS function for finding the number of working days between two dates.

NETWORKDAYS (start_date end_date, holidays)

+8
source
 =networkdays(given_date,eomonth(given_date,0)) 
0
source

Here is an example:

 function daysInMonth(month, year) { return new Date(year, month, 0).getDate(); } MonthDays = daysInMonth(6, 2016); today = new Date(); day = today.getDate(); remainingDaysInMonth = MonthDays - day; console.log(remainingDaysInMonth) 
0
source

Source: https://habr.com/ru/post/1391240/


All Articles