quarter

Hi, I am relatively new to excel vba and I am currently trying to resolve an issue. I have been asked to generate an excel file with randomly assigned quarters to a business unit. There are 11 business units and 11 quarters in scope - the end result being a distinct quarter for each business...

I'm trying to have a textbox default value work similar to a formula. I'm using Me.TextBox2.Value = And I want the value to be ws1.Range(C4) + 1, and if that is >4, then I want the value to be 1. (C4 displays the current quarter, and I want the texbox to default to the next sequential...

I have a macro that clears a database for the quarter, to start fresh with the next quarter. Each quarter adds a few things, so it's not feasible to just start with a blank from the original file. I'm trying to add something to the macro that will save the current file (the outgoing quarter)...

Hi I wonder if any of you experts could point me in the right direction please? I've tried with no success. I have a spreadsheet with staff names across various quarters, I also have a column that indicates which quarter was first and which last. I need to compare row with first and last...

Hi, I checked the other posts to the forum, but the tools were not specific enough. I'm attempting to display a due date based on the current date that coincides with the next quarter or week. Specifically, I want to know: - How I can find the Wednesday before the next month end - How I can...

Hi everyone, I have pulled together a Pivot Table for associates across several years showing production data by quarter for each. The way this is displayed is by "financial year" and then "quarter". Column labels have associate name (John Smith) & Row labels have FY and Q (FY2015 Q1), with...

I am trying to create a worksheet for use by our company and a customer. By contract, we bill for time elapsed in increments of quarter hours with a measure of time that is free and a dollar amount per quarter hour only for full quarter hours. For example, 8am to 5pm with an hour that is not...

I don't know if this is possible, but I have dates in Column 1 (January through December; example: 1/15/18; 3/10/18; 12/12/18). I have times in column B (Example 8:26; 23:13). Sorted by Columns A. I need to COUNT the times (Col B) that appear after hours; from 17:00 through 7:00am, only for...

Hi all, I have these 7 pieces of text that if the header contains them I want to keep them <tbody> SurveyCusAttr SurveyIssueDateSSTZ Location QuestionName QuesAnsKeyEntry QuestID QuesType </tbody> However the source I get them from has different text attached to them a lot of...

This might be kind of difficult for me to explain (it would be easier to show), so please bear with me. I am creating an audit sheet (workbook) for each employee that draws data from several other Excel workbooks. I have everything arranged in a folder and sub folders. For example, 2018 has its...

HI all, need a help on nested if formula for calculating the quarter based on start date and end date follow is the table <colgroup><col><col><col span="2"><col></colgroup><tbody> Date Result Start End Output 03-10-2017 01-04-2017 15-06-2017 Q1 16-06-2017 15-09-2017 Q2...

Hi and thanks in advance! If I wanna know the Week Number of a quarter, I can use, the formula: The Dates are in Column D =WEEKNUM(D3;1)-WEEKNUM((LOOKUP(D3;DATE(YEAR(D3);{2;5;8;11};1)));1)+1 But in my company the first quarter stars the 1st of november, the 2nd quarter the 1st of february...

Hi Everyone, I have a spreadsheet that has a unique identifier in column A, in Column J I have a date and in column R I have a function. What I want to do is pull 25% of the last quarter based on Column, and spread the pull based on function so I don't have all the same function each quarter...

Good Morning, I am finishing up a project that uses quarterly reports and have been re-adjusting my code to be generic and with a drop down box can run macro's based on Quarter 1 to 4. I have one issue left where the report name includes the month of the quarter switching from mar to set to...

Hello, I am not sure if this is possible, but below is an example of a spreadsheet of 1000+ rows , Each row can have upto 3 dates in columns A-C. What i am looking to do is find the latest date in that row and in column D display the Quarter. <colgroup><col width="99" style="width: 74pt...

Hi, i have been playing with various codes to get the Quarter of the date in column K, displayed in column P, here is my latest attempt, could someone tell me what i am doing wrong, have googled but not found any examples of what i am looking for. Sheets ("adviser data") Dim lastrowcolumnA As...

Hi, Wasn't too sure what to name the title so apologies if it is not correct. I need to analyse the frequency that a particular promo for a betting agency pays out on Australian Rules Footy. The promo is if your team gets 24 points up at any stage during the game but looses the game, the bet...

Hello, I am building a new spreadsheet and need to find the last date in a row and evidence which Quarter it falls in as per this example below. <colgroup><col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;" span="3"> <col width="64" style="width: 48pt;">...

Hi all, I have a list of dates and I am trying to state (TEXT) which quarter of the year that they all fall into. My formula is this: =IF(AND(B47>="30/1/2017"+0,B47<="31/3/2017"+0),"Jan-Mar '17", IF(AND(B47>="1/4/2017"+0,B47<="30/6/2017"+0),"Apr-June '17"...

Hey Guys, Currently using windows 10 and Excel 2010. Is there a way for excel to select the data source for Column Charts Dynamically? Example : <colgroup><col><col><col><col><col></colgroup><tbody> Australia Vietnam Indonesia Mexico Quarter 1 10 5 7 2 Variance 1 8 3 5 0 Quarter 2 11...