weeks

Hi there! I was wondering if there is a formula to automatically calculate paid time off per pay period based on a starting date and amount. Each pay period (every 2 weeks on a Thursday) would be 6.1538 hours. Example: May 24 (Thurs) start with 70.1538 and every 2 weeks, June 7 (Thurs) is...

Hi Need some help building a simple formula. I would like A1 to be populated with the name of the person when it's 3 weeks before their birthday, I've created a table array called Birthday, see below <colgroup><col><col></colgroup><tbody> Name Birthday Bert Smith 09-Jun Roger Rooster...

Hi Everyone, I am currently trying to set up a dashboard with information which links to Pivot Tables which are in a hidden sheet. In this dashboard, I wish to use the GetPivotData formula to retrieve data in the table which exceeds the value of 72:00. https://imgur.com/ccnYymS As you can see...

Hi there, first post here. I did not find a direct match to my question, please direct me to the appropriate post if necessary. I need to show the date of the first Monday for a specific number of weeks starting from a specific week from a specific year. Example : first Monday of every week...

Hi all, Looking for a formula to calculate number of weeks between two dates. Essentially I will have 12 columns (Jan-Dec) and will need the cells to pull date from another sheet in the file. It would need to look at the complete date column and pull the data for the month specified in the...

Hi,I am trying conditional formal a cell with a date working of another date.in Cell E6 I have entered a start date and in Cell H6 a review date. I would like cell H6 to show green if within 6 weeks of the start, orange if between 6-12 weeks and red if over 12 weeks.I am currently using Excel...

Im trying to figure out a formula for a weeks of supply report. data i have. Last weeks sales units Last 13 weeks sales units Sales units year to Date Shipment Average units last 13 weeks Total units shipped last 13 weeks On hand units Work in progress units anyone have any recommendations

Hi, I've set up a budget for tasks in weeks. However, the cost ledger is prepared monthly and I am trying to capture my source data in weeks and arrange into budget for the month to enable analysis against WBS codes. On the attached I've used the MONTH and YEAR formula to convert my week ending...

Hi everyone, Just wanted to introduce myself, and say thanks for the help I've received from searching this site over the last couple of weeks. My name is Tyson. I work for an Aerospace Manufacturer (supplier) and do a lot of data analysis. Our ERP system handles the majority of our data...

Hello All, I am hoping someone can help, I have a table on worksheet 1 that contains my data and I am trying to do a front page (totals) on a different worksheet. I am trying to look up and count certain criteria and I can't get it to work.. eg.. worksheet 1 has the below table in and in the...

Good Afternoon, I have come unstuck with an Excel sheet we have after trying to automate part of the document. This spreadsheet tracks costs over a year based on what week it is. Each member of staff has a spreadsheet seperate to this one where they fill in data, and that data is referenced in...

My data set is as follows: In columns starting on C3 I have week ending dates starting with 1/6/2018 all the way to column BB3. on Column C5 i have the week number starting at 1 going all the way to column BB5. C6:M6 contains my data. I need a formula that will average the prior 4 weeks. I need...

Dear All, I'm working a quite big process with a userform with 8/10 buttons doing different things on a sheet. The file il 1400 kb big and it used to be normally fast. Some weeks ago all the processes suddently slowed down but I can't understand why and i don't know where to start to find out...

Hello- I'm still new to VBA and do most of my coding with recording and modification so I may need a LOT of help here. I have a table that lists Part #, forecast values, and dates-in-months. I need to find an easy way to convert the months and values to weeks. E.g. P0421 - 2018M03 - 30000...

I have a tab in a spreadsheet that lists employees taking their vacation in advance. If an employee accrues a week of vacation late in the year and there aren't any more weeks for them to pick due to the limit of vacations being reached for that week, the company will allow them to take it at...

Hello, I am looking for a formula that will tell me the number of weeks left in the current quarter, is anyone able to help me Thank you.

All, I've tried to find someone post a similar question or find a similar use case to find the answer, but I'm not sure I have the right verbage to find my answer. I'm looking for some help with the data below. I have multiple locations going down which I've labeled "red" and "blue" in this...

Hello, so I am looking to see if a formula or other could assign an asterisk to when someone will be due a new vacation in the year based on how long they have been with the company. There are several conditions though, if they are Union employees or non-union, and in the case of Union depending...

Hello all, I am trying to hide a range of dates until I am within 2 weeks then have them show up. For example: Jan 1-3, 2018, Feb 4 - 9, Mar 1-6, 2018 (with actual calendar days) to remain hidden on my worksheet (these are potential vacation days for me), then when I am within 2 weeks of the...