week

  1. C

    Count Days Between Two Dates

    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...
  2. L

    How to automatically update excel without opening it once per week

    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.
  3. S

    Partial Weeks

    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...
  4. T

    Collapse/Expand grouped columns based on cell value

    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...
  5. D

    Date calculating as a number in formula

    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...
  6. A

    Power BI Certified Courses

    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...
  7. M

    Advice on putting values in table

    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...
  8. D

    SUMIF Formula where Excel is treating the Date criteria as Text

    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...
  9. M

    Comparing Weeks with today and selecting the right column

    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...
  10. C

    Weeknumber back to 1 after 52

    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...
  11. G

    Week to date ( Sunday to Saturday)

    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...
  12. V

    Week numbers but in the same month only add up

    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...
  13. W

    Copy target value across based on cell value

    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...
  14. C

    I think I need a V Lookup?????

    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...
  15. J

    Formula will not automatically adjust for different rows?

    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...
  16. D

    Weekly Team and Individual Leaderboard

    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...
  17. H

    Highlight all Mondays (or Tuesdays...) that start a week

    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...
  18. P

    convert function to a Sub

    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 =...
  19. R

    Formula to calculate the number of weeks that it takes for a score to interstect the predicted score

    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...
  20. G

    Number of days of week between two date range by month

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top