weeks

Hi, I would like to create a spreadsheet that I can refresh and pull in each weeks English premier League fixtures, each week I would like to refresh this and see the weeks future fixtures. I have tried to use the import function from Data/From Web and selected the box with the table of...

Hi All, I am trying to write a macro which opens a spreadsheet, whose name has a prefix which stays the same, but the date (mm.dd.yy) changes every week with the following format: ON_mm.dd.yy.xlsx I.e This weeks name is 'ON_08.08.18.xlsx' and last weeks name is 'ON_08.01.18.xlsx'. The report...

I am trying to create an excel chart that will show me my inventory every week for each week of the year so that I can see the trend. I have a chart that I track the numbers daily and then on a different tab I have a chart that does a vlookup to get each Sunday's dates. I have the vlookup set to...

<tbody> on tue wed thu fri sat sumn total available F <colgroup><col width="64" style="width: 48pt;" span="8"><tbody> F 34 34 34 34 34 34 34 G 54 54 54 54...

Not sure how to explain this but here goes. I'm running a football score league and need to work out how to produce a league table for the individual week as an overall league. The overall league is sorted. But not sure how to get the information I need for the individual week as all data will...

I am trying to build a general course calendar that would work for any course whether it meets 3 days a week, one day a week or last 16 weeks. In order to get the class dates listed in column A, I wanted to see if there was formula that would build this list if there was an input of data like...

Hi Everyone, I have been trying a SUMIFS string and have identified the problem within it. I am trying to return a year to date total for column J where the weeks are in column F. If I use equal to M30 it works and returns the sum of the values for the current week but I would like it to return...

I have 52 pay periods that I want to have a pivot table show the breakdown of each week. why can't I have the columns but it breaks it down by year or quarter. I just want all 52 weeks to show

I have been unable to get VBA (not Excel formulas) on how to find the amount of weeks in a given month. Example: for the date of 1/1/2018 there are 5 weeks and for 2/1/2018 there are 4 weeks. This Excel formula seems to work "=4+(DAY(A21-DAY(A21)+35)< WEEKDAY(A21-DAY(A21)-3))", but I need it...

I'm not too sure how to explain this one so will do my best. I have a set of data (parts lists) approx 4000 rows on a worksheet, this is the last weeks data. New data in generated each week, and we need to transfer certain data from last weeks data into this weeks. The new data that is generated...

Hi Everyone, First post on the forum - I have been a long time reader of this forum and have been able to search out an answer for every question I have ever had until today so I finally had an excuse to make an account. I am trying to use the below array formula which is a sumifs to return...

I have a pivot chart that shows Periods and Weeks as shown below, but I want them to run in sequence and find that P10 W1 % P10 W2 does not run after P9 W4. I have looked at everything in the chart and looks ok. Wonder if any of you can help P1 W1 P1 W2 P1 W3 P1 W4 P10 W1 P10 W2 P2 W1 P2 W2 P2...

Hey all I'm sorry if this question has been asked before, but I'm trying to sort a mega spreadsheet to make something at work much easier and simplier Basically every day, someone has to give me a number which I then add to the spread sheet. If this number is '4' I would like the value to be...

Hello All, Thank you for taking a moment to review and see if you can assist. Attached is a copy of the sample data I am working with in Microsoft Excel 32-bit 2013. * Columns A:AS are my weeks 11-25 data to calculate the Pass %. * Some weeks failed (see Week 11 with 0 out of 3), while...

Hey guys, im having some trouble with a bar graph im making for work. I want it to be set up so that it always shows the data for the current week as well as the last 7 previous weeks (so if the data is older than that it doesnt get shown). I thought i could do this with a simple if statement...

Hi All, Is it possible to control a slicer with VBA please? I need the slicer to look for specific weeks. These weeks are in CELs A1:A5 Wk1, Wk2 etc The slicers control a couple of pivot tables. I'm looking to find the weeks that are listed only. Is this possible please?

I have a workbook that has 54 sheets (a TOC, Setup, and a tab for 52 weeks). In the Setup sheet I have 20 products setup and I have a Y/N column next to each product to determine if that product is being used or not. What I want is, if the product has an N next to it and it is not being used...

<tbody> name dept week 1 week 2 week 3 john a 30 30 25 james a 30 30 30 james b 20 - 10 queen b 30 30 30 </tbody> imagine a much more larger data set with more names, weeks. how do you identify the names that worked more than 30 hrs in any week?

Hi all, I have an Excel challenge which I cannot get my head around. I have a planning sheet with multiple tasks and duration, which all have a start and end date. However. Some of the tasks are dependent on others. In other words: the start date of a task X could be dependent of task Y...

I never use Excel to create graphs/charts. I was asked to do one today and I'm having an issue. the data is weekly but the horizontal access should be monthly. It's showing the weeks which of course makes it look terrible. In fact the dates don't line up with the data. Help!