week

Hello, I would be most grateful for help, I am trying to calculate SLA for call attendance based on 7 days per week with operating hours of 08:00 - 18:00, SLA of 12 hours. The only solution I can find uses workday which then does not return correct weekend calculations, I feel so silly but can...

I am working on a sports draft app for fantasy sports. Some background on fantasy sports (this is for basketball), managers draft real life players to create teams, you get matched against with a different team each week, there are 9 stat categories tracked and depending on how many categories...

This spreadsheet is designed to keep track of the number of mistakes made on important paperwork during the course of the week and for the month made by one of the employees in the list. A brief description of the layout of the spreadsheet. In range A3:A51 is a list of all the employees for that...

I have a range (b2:f2) that displays the weekdays of the week(Monday-Friday). In range(b1:f1) I have the dates corresponding with those weekdays of the week. Where I am located the current date is Saturday, the 5th day of October. Which is still considered the current week. So if I were to open...

Hi All, I need some help with this one please. I have a spreadsheet that is a schedule, it lists week by week until the end of the year, this helps us plan out future works but we only send 2 weeks worth to a client. once the current week is over, we 'hide' the week, which in turn moves the new...

Hi All, I have a formula which has nearly 2yrs worth of data =WEEKNUM(TODAY()) issue i have is that means there are nearly 2 of every week. How can i determine in my formula to look at current year only? thanks Samuel

Hi, I have a listbox (listbox1) with the numbers 1-52 in it. I would like a code that highlights the current week when the userform is loaded. Any help would be much appreciated. Thanks Dan

Is there a way to combine these 3 formulas? =MAX(DATE(T2,1,1),DATE(T2,1,1)-WEEKDAY(DATE(T2,1,1),2)+(S2-1)*7+1) =MIN(DATE(T2+1,1,0),DATE(T2,1,1)-WEEKDAY(DATE(T2,1,1),2)+(S2*7)) =CONCATENATE(TEXT(U2,"[$-409]D-MMM;@")," to ",(TEXT(V2,"[$-409]d-mmm;@"))) (T2 is the year and S2 is the week number)...

Hi, Please can someone help me? What I would like is to be able to copy all the data from the current week sheet and then copy it to my data sheet via VBA code. I have 53 sheets on my workbook. 1 sheet for each week of the year and then my data sheet. The data will not be the same amount...

Hi Excel Peoples I've got a table with dates as headers and I want to sum up the values under those dates depending if they fell under this week or last week. <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width...

Hi guys, Just a quick question on how to get a predicted Clock Out time for the week with 60.5 hours MAX. Column1 is the total so far in the week. Clock In Time is Todays clock in time. If the Recommended Clock out time is 12 hours or more away, have it display a text. <tbody> <tbody>...

I have some calculations that are strongly dependent on "this week", "next week", etc. Let's say I have a date (Column A). I can use <code style="margin: 0px; padding: 1px 5px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height...

Hi There I have created the attached planner/job board and require help in doing the following. 1. Under the days of the week. if a date range is entered i want it to auto colour the cells under days of the week. 2. in the engineer list section if i set and engineer to on holiday or sick, i...

Hello, I run a dart league that runs for 30 weeks. I have a weekly worksheet that I enter the scores and the column Z (starting from 2 all the way down) calculates the average =IFERROR(AVERAGE($B2:$X2),0) and the player's name is on A2 of the sheet Then I have my results worksheet that gets...

Hi All, Noob here :) Need help with IF function. I have Data from Cell A2 - K2 Cell's B2 to K2 displayes "Yes" or "No" it compares previous week roster to current week roster I wan't to display Data in A2 using IF if there was changes from previous week to current week. I was thinking of...

Hello, I am doing analysis on products and seeing what the best performing week was for them. I'm doing this for the year 2018 and 2019. On the "Best Week" sheet, which is a Pivot Table (it pulls from a data tab with the raw sales info): Product #'s are listed in column B. Years are listed in...

Hi all I am trying to create a spread sheet version of a project/ job board our job board look like this. Month: September Week Commencing Date: <tbody> Engineer List/Assigned to Engineer List/Assigned to Monday Tuesday Wednesday Thursday Friday Andy John Tesco...

Hi forum, Hoping you guys can assist and resolve this issue I've had for a while. Every month I receive data with three columns. Col1 is hourly segments so a maximum number of rows of 672 for 28 days, 696 for 29 days, 720 for a 30 day month and 744 for a 31 day month. There may occasions...

I have a staffing worksheet that gives me FTEs by week which I need for staffing but I need to submit my FTEs by month for budgeting reasons. I can go through an do this by hand, averaging the weeks together but I am wondering if there is an easier/cleaner way to do this. <tbody> B C D E F G...

I am a superintendent for a construction company and I have a workbook that I am currently working on and I am fairly new to excel. It is for daily reports in which I have to add 4 pictures everyday for 6 days a week. I found that if I use a chart it will auto re-size pictures for me cutting...