week

Hi i have set up a calendar tracker This formula works for recurring weekly appointments where 1 = Mon, 2= tue, wed = 3 etc etc =IF(AB$12=$G12,1,IF(AB$12=$H12,2,IF(AB$12=$I12,3,IF(AB$12=$J12,4, IF(AB$12=$K12,5,""))))) On row Ab1 I have week of month set up, i.e 1,2,3,4,5. So i'd like to...

<tbody> A B C D E F G H I J K L M N ID category week no height weight week no height weight week no height weight week no height weight 2 blue Week 2 98 22.1 Week 3 98.2 22.4 Week 4 98.6 22.6 Week 5 99 23 3 green Week 2 98 22.4 Week 3 98.3...

Please help I am trying to calculate data and find the increased or decreased percentage between weeks: see below : <tbody> <tbody> A1 A2 A3 <tbody> Actions on Page (this wk) </tbody> Actions on Page (last wk) total action % 1 0 0.00% </tbody> </tbody> In A3 i currently have the...

Hi there,Sorry if I am posting a new thread and it has already been answered else where. I have looked and looked, but no luck so far.I have a time & resource planning tool which has fixed data on columns A to G (name , activity , priority etc). From H on wards are week to week columns.What I am...

I am trying to figure out if there is a way to use conditional formatting with data validation list like this. 1st I have a list from data validation of performing a task. I will use 4 task that I do once a week. Mow grass, wash dishes, wash car, clean pool I want to set a time for each, and...

Hi, I am trying to lookup a Power Pivot dates table in native Excel with a formula to lookup the date to return financial week. I have the date in cell K1 in the correct format. Is there a cube formula which can lookup ThisWorkbookDataModel to return the week associated with the date in K1? So...

Hi all, I am trying to solve a pattern problem and need your help desperately. Is doing my head in. So I have a number of clients that have booked an appointment. As you can see in the file the weeks are at the top. What I want to find out for each customer is: 1. count the number of...

Hi there, First my apologies if there is an answer to this already in the forum, but the amount of info is a little overwhelming and I'm taking the quick route; hope you don't mind. There is a register related to my work that I have to check every week to see whether there are new entries or if...

I am using the following code to create a duplicate of an active file and then close the active file. But I am struggling to open the file I just created. Will appreciate some hand holding. Sub Copy() Dim strFilename As String strFilename = ActiveWorkbook.Path & "" & "GJCT Roster Week " &...

https://1drv.ms/u/s!AmfNhO-qyFc5iSnpBImBa6_Ndu_U?e=U3dbXq Screenshot in the link above I'm trying to create a function so that the bills in the top left will auto-generate into the table for the different weeks. For example if a bill falls between the 1st-10th than i would like them...

=IF(H2<TODAY()-14,"Old",IF(H2<TODAY()-7,"Last Week", "This Week")) I found this formula and my only issue is that I want the week to start from Monday to Sunday.. for last week and this week.

I have two columns, one with dates and one with values. Such as: <tbody> 8/4/19 1 8/5/19 5 8/6/19 4 8/7/19 4 8/8/19 7 8/9/19 4 8/10/19 4 8/11/19 4 8/12/19 3 8/13/19 4 8/14/19 3 8/15/19 2 8/16/19 4 8/17/19 4 </tbody> In a separate cell I want to sum up the first...

Hi All, i am trying to work out the difference of sales between current week and the week prior. my formula so far is: =COUNTIFS(Historical!C:C,B2,Historical!$A:$A,A2,Historical!$I:$I,WEEKNUM(TODAY())-1) im struggling to work out how to compare it to the current week. any help will be...

I have a report that I receive weekly Column A will always be Region Column B will always be Color Columns C through Z may change, the order may change, a column that had activity the prior week might not exist because their is no activity. The headers in Column C through Z are known to me...

Hi all, I have multiple charts set up in my spreadsheet showing revenue against email numbers. In all of the charts the horizontal axis is only showing the week number (which is what I want) except for the last chart which is showing three lots of numbers along the horizontal access. One of...

If I have a date in Cell A1 and I want to get the start date of the next week, how is that possible? So: A1 shows 7/26/2019. I want B1 to display 7/29/2019 (week begins on Monday). I know it is some combination of WEEK and DAY but not sure how to do it.

Could someone please help me to write a new formula. Currently I have this: =SUMPRODUCT(('Timing Plan'!$V$8:$V$1032)*('Timing Plan'!$P$8:$P$1032=$C13)*('Timing Plan'!$H$8:$H$1032<BX$7)*('Timing Plan'!$I$8:$I$1032>=BX$7+1)) $V$8:$V$1032 = average required hours $P$8:$P$1032=$C13 = Person...

Hi everyone, please could someone help me. I've created a spreadsheet called example. In it I have 52 weeks of the year with each sheet week number all the staff members that we pay weekly, and their breakdowns. We print these out weekly to attach to their pay envelopes. I then have a summary at...

Hi All, Struggling to add a sample on this one, but hopefully my description will help with what I need: Sheet1 (results required) Sheet2 (Data base information - the look up data) Column B - contains a week number, eg - 1, 2, 3, 4, etc.. Column C - contains names, eg, Bob, Maggie, Paul...

Morning all I'm struggling with coming up with a formula to count the number of managers in a list. I have a dataset that includes week numbers, regions, deals and managers. I need to come up with a count of managers for a specific week and region. I keep coming back with the overall count, I...