week

Hi All, I have a problem with the line chart i,e I am unable to show the data by week wise but I can able to see by day wise. Please help me to show the data by week and day wise like the below screen shot. Please check the my output: I used my order data for my axis and I can see by...

See table below for examples I have a data set with customer order dates Col (1,2,3) - Values I need to analyse the weekly order patterns over a 3 month period, this can be 60,000+ rows of data The array formula looks at these 3 columns and returns a binary pattern for that week. Example...

Hi! I need a formula or something that will calculate a ship day of the week without using an actual date. For example, my scenario is this: x load is delivering on a Monday. The transit time from origin is 3 days. What day of the week did the load ship? The answer would be a Wednesday (don't...

Hello, I would like to match and find a criteria in column A from C1 cell, and then calculate how many cells has values below with including the found one. By looking at the table below it should return count of 4. Much appreciate your help. <colgroup><col><col span="4"></colgroup><tbody> A...

Hello, I am trying to find week number in C1 and match it in column A. Then sum all cells below to the end in column D. In this example it is sum of D8:D11. Is this possible to do?. The week number is going to be changing and would want to know the remaining amount for remaining weeks...

Hi, I have a total worksheet I have 4 worksheets, Week 1, Week 2, Week 3 and Week 4. All set in the same format To get the totals I need from each sheet, I have been using Sumifs. To add up the totals from the different sheets, is there a alternative to...

Good afternoon all, I'm looking for some help with a BI Power Query formula (Trying to cut out lots of manual work) that will take a date from a column (So 10/07/2019) and return back whether that date was Last Week, Last Week -1, Last Week -2, etc up to Last Week -4 in a new column to the right...

Hello, I've really tried to figure this out by googling and struggling. I have a database of drivers which is in order of week number 1 - 52 along the top and their MPG (miles per gallon) per week. (as below). I wondered is it possible to put this into a graph, ideally or some kind of table...

Hi all, long time no posting. I have a report that I need to split into 6 different files, saved in 6 different folders, and then email the new files to 6 different email addresses. I have managed to slit and save the files, but cant get the email part to work. It sends the first file, then...

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

Hello - it's a while since my last question, but I'm totally stuck on this one. I have a sales database which includes multiple columns and my basic quest is to have a formula that establishes if a product has had sales in the latest week so a linked table can say listed/delisted. The latest...

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

Hi. I'm a an excel novice so apologies in advance. I need to create an allocation tool which distributes work evenly amongst teams. We receive a different amount of queries to get through everyday so would need to amend the daily allocation. Each of the teams have different targets which vary...

Hello, I have my first sheet 'Switchboard' that has this formula in Cell E1: =WEEKNUM(TODAY(),2) This yields '28' for the 28th week of the year. My worksheets are labeled Week 1, Week 2, etc. Since this is the 28th week of the year is there a way to jump to that worksheet (Week 28) ...

Hello, Does anyone know code that will copy a template worksheet multiple times? Original Sheet Name: Week Template I plan to have one worksheet for each week in the year (52 plus the 'Week Template' sheet Paste conditions: 1) row height 2) column width 3) fonts style sizes and colors...

Hi everybody, I am experiencing an extremely frustrating problem at the moment. I am putting together a kind of appointment planner for a clinical professional to fill in. The end version will have 5 weeks (each week has its own worksheet and the layout is exactly the same, very standard -...

Hello, Does anyone know of a formula that will total up the Task Times in column I for the day of the week and put in column L? Thank you Excel WorkbookABCDEFGHIJKL3Task #DateDay of WeekAFR NumberShop OrderOtherStart TimeEnd TimeTask TimeDay of WeekCharged Time417/5/2019Friday865968:00...

Hi There, I have a file template with a series of identical tabs containing tables as individual timesheets for various employees. I make one new file each week. Each employee has their own tab and different weeks we may have a new/different mix of employees. I need to take all the tabs that...

Hey All Got a question for you. I am attempting to model a 52 week cash flow model. What I would like to do is, on the input tab, to have the first week the payment will take place, then an input for lagged weeks and the expense itself. See below. The model is run weekly so 25 is the first week...