quarter

  1. 5

    Find previous quarter and display as Q3 or Q4

    ​Hi, I would like to be able to determine the previous quarter from the current date and display as Q2 or Q3 or Q4 etc.<o:p></o:p> <o:p> </o:p> I have the code to find and display the previous month (see below) but am unable to find a similar one for quarter. Thanks in advance.<o:p></o:p>...
  2. L

    To analyse Quarter monitoring from companies into power bi

    Hi All Good Morning I have been asked to analyse Quarter monitoring fromcompanies into power bi The monitoring forms are in excel format with for Q1, and the other tabs would have Q2, Q3, Q4 tabs. the monitoring formformat does not change for each quarter. The information is input into...
  3. reneev

    Pivot Table vs. CountIF

    I have a rather large HR survey that I have to do quarterly which counts certain positions by Full Time/Part Time/Per Diem status. This survey counts these by: headcount, new hires, voluntary/involuntary terminations. Before I came along, it was all done manually. I eventually turned it into...
  4. J

    Formula based on Quarter

    Hi there, I've racked my brain, and exhausted google searches so hoping someone can help me. I have a bunch of data in a spreadsheet that I do not want to manually update when the quarter turns over. So I'm wondering if there is a way to do a conditional formula (and I know there has to be)...
  5. B

    Remove legend where no data in the chart

    I have a doughnut chart that is showing the results for the current quarter next to a column chart which shows the results for the current quarter and previous 2. When there is no data for the current quarter, the doughnut chart does not appear (which is fine) but the legend is still there. This...
  6. A

    Macro to SaveAs PDF but alter the name

    Hi all! I am comfortable with excel but diving into Visual Basic has been slow. I'm sorry if this question has been repeated a million times. My searches haven't found a workable answer. We have our client files in excel .. example "M, Amanda Qrtly Rpt.xlsx" in 4 different folders. The...
  7. K

    Multiple If depending on date

    How do i get a cell to look at a cell and depending on the date divide another cell by a certain number? for example: In cell H44 I want it to look at H6 and if that date is within the dates of the first quarter then divide whats in H35 by 520, if the dates are with second quarter it divided...
  8. J

    ROUND UP FORMULA with IF Function

    I need help with roundup in an if statement. =ROUNDUP(MONTH($G7)/3,0) I've tried everything that I can think of with no luck. Any help would be appreciated. I need Quarter come from Date but if there is not date formula show 0 not value.
  9. D

    getting wrong previous quarter

    i have this: =WORKDAY(EOMONTH(p_quarter,MOD(-MONTH(p_quarter),3)-3),-1,holidays) , which gives me 12/28/18, but I'm looking for 12/31/18 since that is the last business day of the quarter, not 28. "p_quarter" is currently 3/29/19 ....
  10. tlc53

    Compounding Interest

    Hi there, I can see myself spending (more) hours on this so before I do, I thought I'd check if there's any clever cookies who know how to do this. I would like to calculate the compounding interest on a Overdrawn Loan account. I would like the interest incurred to be shown quarterly. In...
  11. B

    Change the color of the last bar in a bar chart

    I have a bunch of bar charts that need to be updated monthly or quarterly. I would like a quick easy way to update all of the charts when new data is added automatically. The far right bar needs to be an orange color as it is not a complete amount for the time frame. An example would be we...
  12. C

    Total Sum Broken Into Parts

    I'm creating a scoresheet and I have a cell that will total the score, but I have other cells that I want to list how many points were scored in each quarter. So in the table below, E3 will have the total score of the game. After the first quarter, I want E3 to populate A1 and then stay. After...
  13. J

    How to Find Overall +/- Percentage Performance Over Several Quarters

    I'm at a loss on this. I need to find the Overall +/- performance % of errors made over the 4 quarters of the year. I can get the performance +/- from the previous quarter but the overall is a mystery. My data is: 1st 2nd 3rd 4th 50% 67% -55% -78% Keep in mind that positive % =...
  14. I

    Rounding using ceiling with conditions

    I'm trying to round to the nearest quarter hour but if the rounding is less than 1:15 I want the cell to just display 1:15 I've tried =IF(CEILING((B2-A2),"00:15")<"01:15","1:15",CEILING((B2-A2),"00:15")) and it just puts 1:15 is every cell no matter if it's above or below 1:15 Below is an...
  15. J

    How to Calculate Throughput by Calendar Quarter

    I need to calculate throughput by quarter for a project, based on units created. For example: There 432 total widgets needed; 22 widgets can be completed a week; how many widgets can be completed by quarter until all 432 widgets are done with a start date of 5/1/19. Can someone help and...
  16. J

    Date Fields

    right i need some help with this. I have to work out a pro rata for people based on the amount of days they have worked over a quarter period. I have a start date for them and an end date for them. first off i want to work out how many active days they have worked over the quarter. so from...
  17. P

    Sum(if statement , if statement, Range)

    Hi, Just wondering for the below formula, if say the particular look up requirement is blank, is it possible to ignore the corresponding if statement? At present, it only matches when the lookup area with content. Sum(if statement , if statement, Range) For instance, =SUM(IF('[Workbook...
  18. D

    Counting Unique names only, based on a couple of criteria

    <tbody> Quarter SR Client q1 jane abc company q1 jane mcg inc q1 jane mcg inc q1 house box llc q1 bob hti q2 bob hti q2 bob apple q2 jane abc company </tbody> I have this set of data. I want to do two things: 1. calculate the number of total unique clients by Quarter and SR...
  19. D

    SUM IF - Quarterly Calculations

    I am needing a formula in my revenue column is only added for the Quarter chosen in column A <tbody> Quarter Revenue Q1 500 Q2 250 Q3 350 Q4 100 Q1 2500 </tbody> I want a formula that will extract only the revenue for each time "Q1" is listed. This can not be a pivot table, as it...
  20. L

    Semi-Dynamic Fiscal Year & Quarter Formula

    I have a workbook with the following dynamic formula that determines the fiscal year and quarter based on todays date. When I run the formula today it will result in "FY 2019 Q2" but when I open the same workbook in April 2019 it will change to "FY 2019 Q3" but I do not want that to happen...

Some videos you may like

This Week's Hot Topics

Top