weekly

I have this spreadsheet that I am trying to create for payroll reminders for weekly, fortnightly and monthly clients. With the Weekly pay clients I need to trigger every Tuesday to be highlighted. With the fortnightly clients I need to trigger every second Tuesday and for the monthly clients I...

I have been charged with coming up with a spreadsheet that will show if someone attended a function each week. I have set up one tab (Weekly Attendees) to include the names and the dates attended. I would like another tab (Attendance) to have the names in Col. A with the Dates on line 1 for 52...

I've got daily data, which I want to convert into weekly. However, the data are not for every day. In some cases, it could be from Monday to Sunday, in other it could be only, say, Tuesday and Thursday. Basically any combination. I have a table with a date and a number for that day. I need to...

Hi all i am trying to use the formula from the tax website in excel but i don't know how to remove the numbers behind the decimal i.e the cents. The formula is as follows Y = AX - B Y is the tax A and B are from the tax table X is the weekly amount earned. For example fortnighly pay =...

I might be approaching this completely wrong. Please feel free to scold. In my workbook I have a sheet called Master Tracker for tracking all things including installation dates. Weekly we receive an updated file from another team called Weekly Updates that has install date changes. What I...

This has been bugging me for some time now. How do you calculate a exponentially increasing Weekly Goal %, over a 52 week year, that sums to 100% at the end of the year. I don't have a particular starting point... just know the sum of the 52 week percentages has to equal 100%. This % is used...

I am trying to sum an employee's PTO. They only qualify if they arrived at work on time every day of the week. I have created a formula to say "yes" if they were on time and assign the daily value (1/7th of weekly value). Then there is a column that sums up the daily values. The next step...

hai all,i'm a new guy.i'm trying to make a progress report which wil be calculate in percentage,the formula i'm using is like this (COUNTIFS('WEEKLY REPORT'!$H$6:$H$79,"COMPLETE",'WEEKLY REPORT'!$F$6:$F$79,"HMU/DMU T03",'WEEKLY REPORT'!$G$6:$G$79,"D1")/(COUNTA('WEEKLY REPORT'!$J$6:$J$79)-1) and...

First of all "Thank you" for reading this message and considering some help with my questions. Attached is a department schedule pdf. and I need a spreadsheet done so I could view it with the bar graphs and also a weekly spreadsheet to my weekly dates. My knowledge is best at "novice of excel"...

Hi All, Happy Holidays Need some help on a project. Trying to calculate this for someone, if they work weekly # of hours at a rate of $13, but now we change the rate for $15, now this guy wants to keep paying the same weekly amount dollars from the $13 rate, when they make the $15 amount. So he...

Good Afternoon All, I've got a set of resource usage graphs over time built in Excel. Every week, I go in and update actuals through the current period, and also update my forecast for all future periods. So for example: week 5 - weekly actuals are in columns A through E, and weekly forecast...

Hi guys! I am in need of VBA code that will copy data from one sheet and paste it into another sheet with some slight modifications... I have some data that is in the current format of:(Columns A through N) <tbody> Name Employee ID Weekly Start Date 1 Weekly End Date 1...

Hi - I am having some problems with the following (which I am trying to solve in stages). Ultimately I want to cell to read (spanning over 2 lines); Final Score October (if weekly) or September (if monthly) The text 'October' sits in cell M2 of LastGame worksheet and is subject to change The...

Hello- Thanks in advance for any assistance. Looking to have a column in excel which calculates the number of times a name appears weekly in a data set over time and assigns an integer to the name. The "Occurrence" column would auto populate the above target value. I was using '=...

Hi, I have a task which I am having trouble finding a solution. I have an worksheet (B) which is populated by data from another worksheet (A) The data in sheet A is put into a number of different tables in sheet B based on a particular value (in this case if the data is weekly, monthly...

Hello Folks, I am preparing a daily, weekly and monthly report. For weekly report I need a weekdays order from Thursday to Wednesday. When I pull data for this week in the filter it should filter from Thursday to Wednesday. Please suggest an idea whether in vba or formula. Thank you.

<colgroup><col span="3"><col span="3"><col><col><col span="2"><col><col><col><col><col><col span="2"><col><col><col><col><col span="2"><col><col><col><col span="2"><col><col><col><col></colgroup><tbody> 01-Jul-18 02-Jul-18 03-Jul-18 04-Jul-18 05-Jul-18 06-Jul-18 07-Jul-18 08-Jul-18 09-Jul-18...

Hi, I'm trying to forecast weekly cost of equipment and rounding up the weekly costfor a full 7 day period so if a hire commences on a Thursday or a FridayI'd like to round up to the Monday howver I cannot seem to get the formula towork: B3 = Hire From Date of 31 July 2018 C3 = Anticipated...

hi & good evening. i have a worksheet that on a weekly basis needs the tab changed but will always have the same text after it IE This bit changes weekly-This bit never changes This bit changes weekly would use the info in cell D1 very much appreciate your help. KR Trevor3007

Hi there, I have created a template with session 1, 2 and 3 for my athlete's weekly schedules to be input for each week of the year. These are split into 4 weekly blocks in which I have 1 tab for each. i.e. Tab1 would contain weeks 1-4, tab2 contains week 5-8 and so on... I am now creating a...