weeks

<colgroup><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"></colgroup> <tbody> <colgroup><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"></colgroup> <tbody> Invoices Name2 Priority...

Hello, I am having difficulty since I have never used Excel to understand a great deal of what I am reading. I need to count out weeks, 4, 6, 8 depending on what client I am working with from July 15 - December 24 2019. I cannot figure out how to use the excel sheet to make that happen. Can...

Hi, Hoping someone could help me with the following please, I am looking to find the average of a range of numbers (determined by the variable in the 'weeks average' cell) So in the below examples, I want the average of the last 5 weeks for each set of numbers. I want to ignore any zeros...

Hi There, I am trying to get a weighted ranking that uses dollars as the highest weighting. We are looking at a list or items and evaluating their weeks spent below their intend MSRP and wanted to rank them by importance using a count of the weeks below MSRP and their YTD Sales to rank them...

Hi All, I have a start date in C1 and an end date in D1. I need a formula in E1 that tells me the total number of times Fri, Sat & Sun would be in that date span. Keep in mind the dates are user input so they might not always be full 7 day weeks that are entered so I can't just count the...

Hi there I have a column of dates and I have been asked to do a formulaso when two weeks have passed from the date shown (14 days) it highlights it. E.g : 01/04/2018 highlight after 15/04/2019 = 14 days past(2 Week) Many Thanks Leicester City Fox

Hi all, Pretty new to VBA, trying to work things out for myself, but I've become stuck. Basically every Monday my colleague downloads a spreadsheet of direct sales (Main Tab), I then create a summary (Summary Tab) where I have every date of the year which is split into weeks. Next to each week...

Hi all, I've found the formula to calculate the week of a month, but I'm looking for a formula that calculates days 1-7 of the month as Week 1, days 8-14 as Week 2, etc. Is anyone able to help please? Thank you in advance!

Hi All, I am hoping someone can help me design a formula for my excel project. THANKS in advance! I am required to calculate the gestational age of a baby (in weeks and days) at a particular point in the pregnancy and also after birth. I have the date of birth of the baby and the gestational...

Hi, I want to create an array formula to count the number of weeks that inventory is held in stock - as per the table to the right. What formula is necessary to count this? <tbody> <colgroup><col span="2"><col><col span="2"><col><col><col><col span="3"><col><col></colgroup><tbody> WEEK...

Hi All, I need to carry out 6 weekly and 10 weekly inspections on our units and trailers. How do I set up the sheets so that:- 1) It automatically records the next date of Inspection and respective dates for the next 6 months so that I have a list of due and completed inspections. 2) On...

so every wed, I send out an e-mail so I'll be sending out an e-mail Feb 13 (wednesday), but the report is actually spanning from Feb 6 (last week's wed) to Feb 12. note that if last week's wed was a holiday, it would be from Feb 7 (Thur) to Feb 12. I've already made a table to take into...

Hello, I would be grateful for some assistance, please. My company uses 13 'periods' of 4 weeks each for it's reporting. How on earth can I get excel to be able to produce reports using "normal" dates from the data source, but then somehow referencing them against the year/period/week? I...

I've got a list of samples and would like to chart them, summarized by week number. Some weeks have 0 samples, some weeks have multiple samples. When I create a PivotChart, I can group it to summarize by weeks; however, it only displays weeks with samples and omits weeks with 0 samples. To the...

Is there a formula that would let me flag that last ten weeks from current date, taking into consideration that week 52 (sometimes 53) rolls back to week 1 For example.... Below is column A (The date) and B (the flag) I'd like the formula to look at the date in the cell and if the date in the...

Good Morning Guys, I am looking to develop an S-curve in excel and have searched all over the internet but not getting any suitable ones. The best one i found in terms of shape was the following: http://www.clear-lines.com/blog/file.axd?file=S-Curve.xls However this one is built in years...

I have a table setup that in column A has the Quarter of the year (i.e. 1st Qtr, 2nd Qtr), and in column C it has the month, and in column D it has the week (week 1, week 2). I have the weeks broken down based on date on another sheet, but what is the easiest way to get the weeks aligned by...

Hi All, I am using the below array function to count the number of weeks which are meeting the criteria of >=100, from last 4 weeks which have scores and ignore the weeks containing 'NA'. However it is not giving me the desired answer. The formula is working fine if the criteria is <100 but...

Hi All, Im trying to resolve below issue form a while. Currently im trying to build forecast vs stock calculations to show me weeks of cover. Im not looking for average but to calculate in Wk2 i have stock enough for ... weeks with the forecast value as .... Also include negative stock (to be...

Problem Statement: Column B through D track a rolling count of items that are open and closed for a duration of the last 30 days based on today's date. (Blue table) I'm trying to accomplish the same function by using rolling weeks instead. (Yellow Table) This is simple, but I've been at this...