weekly

Can someone share or point me in the direction of a spreadsheet template where I can enter in my bills due and figure out how much in expense versus income for the bi weekly pay periods? any ideas would be helpful as well.

https://imgur.com/a/WsMJj Hi all, Above is a screenshot of the sheet that I am using to calculate payments. I want to put a formula in B13 that automatically works out the weekly fee that each client has to pay. The weekly fee is determined by the total number of orders (cell B4) and you can...

Hi All, Me and my friend were working on an idea where we could pull total business hours worked excluding holidays and weekends so we started googling and got lucky with this formula =(NETWORKDAYS.INTL(B2,C2,11,A2:A100)-1)*("START TIME"-"END...

Hello all, I am working on my yearly workbook for timesheets. We do weekly timesheets so in cells D10:L10, there is a date i.e. 1/01/2018. Every tab is labeled for the beginning of the week, 1-01, 1-08, 1-15, etc. How do I enter 1/01/2018 on tab 1-01 and then it would autofill all of the...

Hi everyone After scouring the Forum for answers, I have come up blank. Can I please pick your more experienced brains on this one? I need to consolidate daily data into weekly data onto the same sheet. Each day data is entered into the sheet and needs to produce a weekly total of product and...

So I have 2 pages one is broken down with weekly data and I have another page that has monthly data but I want to pull the most current weekly data. Weekly columns would be identified as example 8/4 8/11 8/18 and Monthly is just August 2017. Is there a way to pull the most current 8/x data to...

I have a workbook that get built every week (Work Status) the previous weekly status workbooks are saved on a network share. I am trying to Dynamically change the workbooks name and retrieve Cell values from the previously saved workbook. Previously saved Workbook: Weekly Status...

Hi, I am Trying to create a weekly moving dashboard for ranked values. I have a clue of how can i get the top three ranked validations from a list , but i am not able to link these validations to change with my week. Source Table: <colgroup><col><col><col><col><col><col></colgroup><tbody> Week...

I have been attempting for some time to automate compiling weekly reports that I receive. The following is what I have written, and I can't figure out why it doesn't update the value of cell B39 to reflect to the newly received sheet. This macro runs fine through to the range("B39").Value...

Hi, I have 2 worksheets one daily and 2nd for weekly. I look for the week number using WEEKNUM Daily sheet look like this <TBODY> Date Week Number Time Taken Qty Completed Row No 26/02/2013 9 65.00 25 2 26/02/2013 9 435.00 183 3 27/02/2013 9 310.00 500 4 27/02/2013 9 18.00 30 5...

Hello, Basically I have a list of zipcodes and I would like to create a webquery which will pull back the average temperature, rainfall, snowfall for a week (last week or other historical weeks). I found a website which has this info: http://www.wunderground.com/history/ and I can put in a...

Hi all, I have the following setup: 52 weeks of 2010 cost with the following structure: week number | wk1 | wk2 | wk3 week ending | 1/10/2010 | 1/17/2010 | 1/24/2010 weekly cost | 57,000 | 35,000 | 42,000 I want to be able to use the above data to present a...

Is there a way to have a weekly date range that updates automatically? For example, have the line read "Saturday July 2, 2011 - Friday July 8, 2011" and once July 8th has passed, have it automatically update to "Saturday July 9, 2011 - Friday July 15, 2011" Thanks in advance!

Hello, I am having some trouble coming up with a code that does the following: There is one sheet in wich people type some numbers every day, once the week is over, they delete the numbers from the previous week, change the dates and start recording the numbers for the next week. What I need to...

I need to SUM weekly spreadsheets onto a monthly spreadsheet summary sheet according to personal name. Rather then clicking each individual cell to add I would like to know an easier way as the reference position can change on each weekly sheet and clicking pages of cells is very tedious. I have...

(This is Sooo Bad, I had all this typed and lost it in the preview) (This time I "ctrl+c" everything before preview) (In preview my pic didn't show, I used the wrong link: "Use the second one") I am creating a weekly expense report that includes pay Daily Hours <= 8 $10.00 Daily Hours > 8...

I'm trying to create a budget worksheet. I want to be able to enter my expenses and have the sheet tell me how much that expense is for 1 week, 1 month, 6 months, and 1 year. Let's say I enter Rego - $260 a year. 1 week would be $5, 1 month $20, 6 months $130. The problem is, the way my sheet...