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()
The Analysis Tool also provides the NETWORKDAYS function for finding the number of working days between two dates.
NETWORKDAYS (start_date end_date, holidays)
=networkdays(given_date,eomonth(given_date,0))
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)
Source: https://habr.com/ru/post/1391240/More articles:C # Converting String to double precision loss - c #Map of different URLs for the same web application in Tomcat - javaDoes my Facebook app also work in iOS / android apps? - androidC # send email using implicit ssl - c #Convert Erlang UTF-8 encoded string to java.lang.String - javaSQL query that returns aggregated and non-aggregated results - sqlIOS Controls - iosIs there any property on SQL Server that is similar to Oracle's automatic constraint? - sql-serverDebugging triggers (or why does this trigger not work?) - debuggingIs there a library for the SECS / GEM protocol? - delphiAll Articles