workdays | Extend python datetime with excel-like workday addition

I am working with MySQL and am trying to combine two Subqueries. It is about time and excluding timespans.

The first (working) query fetches me every single valid day between two dates that are neigther saturday nor sunday (workdays):

I have a vacation excel where the worker vacations are calculated. My country has postponed holidays where we have to work on weekends. I was wondering if it is possible to add a list as I did with holidays in the NETWORKDAYS formula. How can I make an excel formula that if sees a date in a list that is between 2 dates to add it automatically (count as a workday) so I don't have to do it manually? Have a nice day!

I use the below calc to calculate workdays in a month. i.e for calendar date = 28-05-2021 , i get 23 days ( monday to friday)

When I try to Enter details in my project It gives an error in the first try clause that reurned value from the database doesn't get inserted into local variable. It seems the value is not parsed to an integer and gives an null value insted.

connector, preparedstatement,Resultset values are not defined here in my code but in the actuall programme thhey are connected properly.

*

How do I go about calculating number of workdays in a MONTH based on a date in another column?

Example: Column 1 - 2020-06-30 Column 2 (Calculated) - 22 (i.e number of workdays in the month of June Mon to Friday)

Does BQ have a WORKDAY function?

I have the following dataframe called df1 that contains data for a number of regions in the column NUTS_ID:

The index, called Date has all the days of 2010. That is, for each code in NUTS_ID I have a day of 2010 (all days of the year for AT1, AT2and so on). I created a list containing the dates corresponding to non-workdays and I want to add a column that with 0 for non-workdays and 1 for workdays.

For this, I simply used a for loop that checks day by day if it's in the workday list I created:

Ok, so what I'm trying to do is for each month count the number of workdays, minus public holidays.

I'm working on a module extendig Odoo's Attendance. My goal is to make only records meeting a condition editable while others stay readonly.

I've created an additional field user_editable to imitate the future condition, but alas this does not work. All shown entries are set to readonly.

What am I missing?

These are my record rules adapted from existing ones.

I am looping through products (variable records) with a bulkWrite updateOne operation on each product.

Once I update the records I can see the reservations array is being added to the document, totalQuantity is updated to the expected value (e.g: if the totalQuantity is 2000 and the loadingTotal is 600 then the updated totalQuantity is 1400)

As you can see in line $set: { currentQuantity: "$totalQuantity" } I am trying to assign totalQuantity(1400) to currentQuantity. But this is not working.