weeks

<tbody> 1 A B 2 3 Date fie Reviewed 11/30/2018 4 First Date of Item Entry 12/15/2014 5 Last Stock Date 9/18/2016 6 Final Inv. Date 11/30/2014 7 Weeks on Promo Disp. 90.43 </tbody> I am trying to figure out a way to turn this into an automatic...

Hi, Our lead time is 6 weeks from Booking Date but some Customers put a Requested Date of further out, eg. 8 weeks from Booking Date. If I run a simple LT calculation, we will always fail to meet KPI because the we are delivering 8 weeks not 6 weeks. Is there a formula or calculation that can...

I'm trying to replace an Input box which requires input of a Monday (19/11/2018) or (26/11/2018) or (12/11/2018) for instance, any Monday, but only monday. I want this to go on a Userform but I've never used them before. The form needs to have a manual box for inputs where a user can input a...

I have 4 reports that I get The data in these reports is simple, It contains one column with the customer code and a second column with an order entry date The 4 reports are Orders for the last two years Orders for the last Month Orders for the last 3 weeks Orders for the last two weeks I...

Hello, As a team, we use an excel to document accomplishments for each project we are working on. We make updates to the accomplishment section in the excel document every 2 weeks. We are looking for an automatic way to roll-up accomplishments from prior weeks into one column. Our initial...

Hello, this is a bit of an odd query, I am trying to convert a student timetable into an excel spreadsheet (then create a calendar with it), but the data I have been given is in an awkward format. It would be easier to give an example: I receive a cell containing a list of weeks a certain class...

Hello, this is a bit of an odd query, I am trying to convert a student timetable into an excel spreadsheet (then create a calendar with it), but the data I have been given is in an awkward format. It would be easier to give an example: I recieve a cell containing a list of weeks a certain class...

Hi, Each week I need to report the departments numbers to the stakeholders and they require the last 12 weeks of data split into last 6 weeks and previous 6 weeks. Is there a way for the tables to move along each week when I add new data without having to go in and adjust the dates? Thank you.

I posted here and got some help, but not exactly what I need: https://www.excelforum.com/excel-general/1248831-dynamicaly-linked-cells-based-on-the-month.html#post4989975 I will do my best to explain what I need My company went to a monthly calendar reporting period with 12 reporting periods...

Greetings, I'm trying to avoid my LOOP which loops every 7 seconds for 5 days 24/7. Some weeks no worries. Other weeks nightmares. What I'm trying to do is quite straight forward but I have no idea other than calling each sub on a continuous loop. What I'd love is this instead of Looping over...

Hi All, Looking for a little help with the following please, I want to find the average according to the variable in the "Average Weeks" cell. So in this example it would look at the last 3 weeks figures, Weeks 4 - 6 and work out the average = 9243 As in the example, the future cells Week...

G'day Everyone, I hope you can help me with a counting issue. I have a spreadsheet that tracks project status changes that's updated weekly. Every week project managers show their overall project status using a RAG status. The colours correspond to numbers as below. Green Amber Red I want...

Hi there, I'm super glad to have found you all! I am looking for a query much like this one - Date()-Weekday(Date(),2)-56 I don't want it to be all the dates inside the 56. I just need the query to pull the Sunday from 13 weeks ago date data. Can that happen? I have a lot of different queries...

I have no idea if I am dreaming with this but I have a series of spreadsheets (30) that output data that looks like the attached at the bottom of each sheet (one for each player). https://1drv.ms/u/s!AiBk9WsyEESSgpVxt_0_XjHt6lYRbA Now if I had to I could manually paste all these into one...

Hi everyone, I know how to create a dynamic chart title based on the contents of a cell. What I want to achieve is a Pivot Chart dynamic chart title based on a slicer that is showing Week Commencing dates, I show the last 13 weeks, so what I want is to be able to show the first date and the...

Hi Everyone, I thought this would be simple but i'm struggling because of a few unusaul aspects hopefully someone will understand. So I have sheet Named "All Weeks Data" This hold my data each week. in Row 1 are Dates going up one day at a time from 1st JUne 2018 My other sheet is an input...

Ladies and Gentlemen, I have just taken 2 excel courses and I was unable to figure out how to do this based on the knowledge I received. I work for a construction company and I am trying to make life easier for us all. I have a table with 3 columns. Column 1 - "Due Date" (This is the date in...

Hi guys, I am running into circles with trying to figure out this issue. I am wanting to automate our current capacity planning tool for my team and want to generate some sort of forecasting ability with the forecast formula. I have heard that the newer versions of Excel contain the forecasting...

I have set up a gantt chart using excel formulas- with the start and end dates of activities, however I have been told that the activity only happens once every 2 weeks - can anyone help with the formula to edit what I have done so far.... =IF(AND(G$9>=$D18,G$9<=$E18),"X","") This is where I...

hey everyone im creating a simple task list that is seperated by days (Sunday through Saturday) 3 different task split between 3 different people beside the task there is a drop down menu for whoever is assigning tasks for the week - however though my question or problem im having is that im...