mondays

Hi I was watching a video on how to calculate # of mondays between 2 dates. He used this formula = networkdays.int(start date, end date, "0111111") I understand 0111111 to show only Mondays, 1011111 to show only Tuesdays etc but my questions, why he used that as 3rd argument when the 3rd...

Hey folks, Can you help me with a question for my school? We have children who attend breakfast club. On one sheet we list ALL the children and how many days that term will attend breakfast club (e.g. 5 Mondays, 6 Tuesdays) - this is so we can bill correctly. I want this to automatically...

I am able to use a formula to calculate the mondays in a month when the user enters a date, example, entering July 10, 2019, states that 3 mondays are left within that month which is correct, but i need to set a range of cells with that formula and i am trying to use VBA to do so, but it gives a...

Hi guys, I have a question I was not able to find an answer anywhere so I need to ask your advice, hope you can help me :) When I use Filter condition "Last week" it always considering the week from Sunday to next Saturday, is there an option to setup this to consider the week from Monday to...

Hi all, I was trying to summarize just a few hundred rows of annual data today in a simple 3 bar column pivot chart. The main things happening were i) date and ii) # of customers seen by business on those dates. My requestor was looking for 3 specific things in the same pivot chart: a) total...

I have data in sheet 1. There are dates in B2:H54. Column B is always Mondays and C is Tuesdays and it continues until Sunday in column H. Then in I2:O54 is the data that corresponds to my dates. So column I is always Mondays and column O is always Sunday. The data on sheet 1 will be updated...

Hi All, I am trying to figure out how to calculate the number of REMAINING mondays, tuesdays, wednesdays, thursdays, fridays, saturdays and sundays in the current month. Any idea on how to do this? Thanks!

I am looking to make a clustered column chart. I've given some example information below to show what I'm looking for, more or less. I want my x-axis to be non-numerical labels, which I have listed in column A of my spreadsheet. I want my y-axis to be numerical values, which I have listed in...

Hi all, I need to calculate how many Mondays, Tuesday's etc. an employee worked over a given time frame. It's not as simple as "tell me the # of Monday's between January and May.' See my condensed example using Thursday (i.e. how many Thursday's did this employee work between January and May...

I am trying to prepare a list of Monday's which excludes any holidays lists but I can't seem to get it to work. I tried the WORKDAY function but then it skips the Monday and returns the Tuesday. Example Cell C4 is the previous Monday 10/02/17 And holidays are listed in cells J5:J30 which...

Hi all I've got a worksheet function using SUMPRODUCT that will count all the Mondays in any given month. It works if I put it on a worksheet quite nicely. The formula is this:- =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(EOMONTH("05/01/2018",-1)+1&":"&EOMONTH("05/01/2018",0))))=2)) You can swap the...