week

I thought this would be simple but my attempts are not working for me. I need two things PLEASE. I am trying to calculate the total number of "days" between two dates, and secondly, calculate the number of "week days" between the same dates. Each would be in a separate cell. I am totally...

Hi, Right now, once a week I need to open a file, refresh the table, save and close the file. Is it possible for excel to automatically update itself without opening it once per week? Thanks in advance.

I am trying to create a formula or script that will identify partial weeks. The end goal will be to yield if a month ends in the middle of the week I want to have the week start date be the same and the end of week be the last day of the month and the start of the next month be the first day of...

Hi All, I have a worksheet with 52 weeks of personnel planning. These are grouped columns with an empty column in between each week. The groups are in columns E:PL. Each of the weeks are named ranges. Columns A:D have text (ie. work path, area, etc.). For the user, the columns are frozen to...

Hi All, i have a formula which im trying to calculate a percentage based on historical data by week Formula: =(Networks!$C$62-COUNTIFS(Historical!$A:$A,Q$16,Historical!$I:$I,WEEKNUM((TODAY())-P27)))/Networks!$C$62 I believe the formula is correct, although when i "evaluate" the formula it...

Hi, my company is prepared to put me through a Power BI course and have asked me to find a course that fits our needs: > Preferably a week / 2 week classroom based intense course > Certification included, Microsoft 70-779, MCSA or MCSE exams as part of the course > Preferably a Microsoft gold...

Hiya I have a table where I have a simple sumif formula to calculate for each week Each week when I run an update, I need to paste the week I’m running as values so the table will have inconsistent table formula my question is that can I do that so the table formula can have cells in between...

Hi, I have a very simple SUMIF formula =sumif(L:L,O6,H:H) Where L:L are week commencing dates and O6 is the week commencing date I want summed from numbers in column H:H. As I'm building the formula, I can see it is treating the dates as a number, 43464. The result should be 22, but I keep...

Hi All, I am trying to create a column that is basically, giving the variance of this week, to the previous week. I want to make this as automated as possible. An example is below: So in the table there are 5 columns with 5 dates, and I need in the 6th column to have O2-N2, and I need this to...

Hi all, can anyone help with my query please. On our SS Columns AH2 onward contain data in week numbers, but it does not stop at 52 & revert back to week 1 for the new year Below is the formula in AH2, cell AH3 = AH2+1, cell AH4 = "AH3+1" and so on...

Hi, I need to create a dynamic bar chart that shows data from Sunday to Saturday for current week. If column A contains dates, column B contains values to be displayed in bar chart. I want the bar chart to always start from the most recent Sunday and chart each day of the week until Saturday...

Hello All I am trying to add up multiple rows of date to show the outstanding sales for each week At the moment I am using the formula WEEKNUM using the daily date The issue I have is that the WEEKNUM sometimes rolls the date into the next month which I can't have I have to be accurate to...

Good Evening All, I don't know if this is possible and am really struggling with this problem. We have a sheet which lists how many actions are needed to be done and what week they will start closing them out followed by how many weeks it will take them. This way we can give them a target...

I could use some help with a V Lookup. The first sheet is a list of names in column 1 in columns 2-5 those are weeks in the year based on the second sheet. Said person can select any of the 52 weeks and up to 4 different weeks. I am working a vacation bid where people select which week they want...

I could use some help with this formula: =(SUMPRODUCT(COUNTIF(INDIRECT("'"&$A$32:$A$34&"'!B11:K11"),"<>"))) This formula is counting the amount of times a value appears in cells B11:K11. The cells A32:A34 refer to the names of different worksheets – Week 1, Week 2 and Week 3. The formula itself...

Hello, I'm lost (per usual) and have searched long enough that I'm starting to go insane so my next step is to post my questions here. Our sales team is needing/wanting a leader board to not only monitor and display the individual sales but also the team (groups of 4 people) sales. So every...

Hi. I am using CF to highlight all Mondays in a week using this formula =WEEKDAY(P5)=2 When I populated the dates from left to right across my columns, I filled right with this formula: =WORKDAY(S5,1,Holidays) However, since I've got my Holidays range to ensure that bank holidays aren't...

I found this function that calculates the week of a month and it works great on a spreadsheet but I need to work on a userform. Function WeekOfMonth(dDate1 As Date) As String Dim dDate2 As String Dim wWeek As Integer 'dDate2 is changed to date from String dDate2 =...

Hello, I came up with a way of gauging student progress, and I’m trying to write a formula for that purpose, so I can test the method in larger scale to see if it’s any good at all. Here is what I do: I take each student’s week 1 score and subtract it from the week 5 score (e.g. 88-76), and so...

Hello, I am looking to get the following result: So basically I need to figure out how many turnaround( airplane comes in gets services and departs with another flight number to different destination) I have between two dates and week days. For example: Start End...