1. B

    Use AVERAGEIFS based on dynamic criteria

    I'm trying to average a set of cells based on multiple criteria (hence the AVERAGEIFS), but I want this average to change as more data is added. There may be a very simple fix for this, but I can't figure it out for the life of me. Below is a sample of the table followed by an explanation of...
  2. U

    Recurring Tasks Calendar

    Hello you all! I've been looking for a way to automate a calendar that I use and as of today I fill it manually. It is a calendar of recurring tasks but they change through the weeks of the year. For example I have tasks that are on mondays every 3 weeks. Others that are monday, wednesday and...
  3. J

    Edit chart category axis data items visible in VBA

    HI all, I have a workbook that crates a group of charts on a single worksheet. Each chart is based on 39 weeks' of data, but I want to show the last 8 weeks only, or be able to switch all the charts to show week 7, 15, 22 etc (it is school data, so weekly for now, but eventually the end of each...
  4. 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...
  5. 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...
  6. 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...
  7. D

    Find current week number from 2 different listboxes

    Hi, I had a listbox (ListBox1) with all 52 weeks of the year in and Fluff very kindly supplied me with this code that worked perfectly for me: Me.ListBox1.Selected(Application.WeekNum(Date) - 1) = True But because the listbox was so long I have decided to use 2 listboxes (ListBox1, ListBox2)...
  8. D

    Is it possible to be able to tidy and make my code quicker?

    Hi, I have a list box with the 52 weeks of the year in listed as WK 1, WK 2 and so on up to WK 52. So when a week is selected from the listbox all the data is copied from that week sheet on to my current weeks data sheet. Here is part of my code. Its is all the same apart from the week...
  9. B

    Update excel value based on day of the week

    Hi, I'm creating a spreadsheet with a list of all my employees, however rather than updating their availability daily, is there a code so that their shift is updated depending on the business day within every 2 weeks? Ex: Employee A is off on the 1st and 2nd Wednesday every 2 weeks, so when...
  10. M

    Cash Counting sheet

    Hi Everyone I am pretty good at excel until it comes to layout.. I’m a Treasurer with a local soccer club and we have a snack shack that I am responsible for. I need to create a sheet where I can enter the total number of notes for each denomination but here is the tricky part I need to do it...
  11. L

    Macro to compare previous worksheet only to new worksheet.

    I have a workbook that is used to keep track of hub mileage (in column B) and hours ran (in column C) of trailers. A new sheet is added weekly to record that weeks data. I am trying to come up with a macro that will compare only the previous weeks data and throw up an alert if the mileage gap is...
  12. G

    Line graph with two data sets

    I have a graph which tracks two sets of percentage values by weeks on the x axis. The data is in two adjacent columns and works well if I have multiple rows of data. I use code to set the data source using a dynamic range. If I remove all rows other than the first, the chart shows two points...
  13. H

    Count of cell blocks

    Hi all, I am trying to solve a pattern problem and need your help desperately. Is doing my head in. So I have a number of clients that have booked an appointment. As you can see in the file the weeks are at the top. What I want to find out for each customer is: 1. count the number of...
  14. W

    Calculate date

    I am trying to calculate the date in weeks by putting a number in a column A1 14/8/9 A2 6 A3 calculation of date in 6 weeks time The number in A2 could be any number of weeks Thanks
  15. D

    Help unstanding this formula?

    Hi, please can someone help and tell me what this formula is looking for or doing? =OFFSET('Current weeks data'!$A$1:$W$1000,,,COUNTIF('Current weeks data'!$K:$K,">"&0)+1) It's the last part I don't understand but if you could explain it all just incase im mistaken. Thanks Dan
  16. C

    Averageif across multiple sheets with variable content

    Hi there, I am trying to do an average of data on a summary sheet from multiple sheets, however, the data I need is coming from an already existing averageif formula on each sheet. I have set up the columns and rows to be exact on each sheet for the values needed. Each sheet will be labeled...
  17. P

    How to ignore cell if its filled?

    So I have two worksheets. Work sheet 1 has monday tuesday wednesday etc. Week's data. In Work sheet 2, i want the sum of entire week to fill cell A1 (week 1). In second week, cell A2(week 2). And so forth. Now in A1, i wrote =worksheet1!sum(cell). The issue is, as i update the worksheet in...
  18. T

    Vba or Fomulas to give me 4 dates from a start date and duration

    Hi Everyone, Hoping someone can help with this, I would like to input a start date and durration and get 4 dates equal weeks apart from that info. So for example D2= Start Date, (I input 01/July/2019) D3= Duration in weeks (I Input 4 weeks) So I would get the following dates in range...
  19. E

    static date on specific cell

    Hi, I can't seem to find an answer to this one anywhere. I have supervisors who add required delivery dates to a shares workbook. For example, if they want something delivered in a weeks time, they would add 1st June. I want to also log the date they put the date in, so that it doesn't update...
  20. gymwrecker

    Calculate Number of Weeks Formula

    Need help with a formula to calculate the number of weeks that have passed based on TODAY. I specifically need complete weeks. A1 = 4/29/2018 A2 = ??? (Number of weeks) (Today - A1?) Note: using MS Excel 2013

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