1. realPrincessApril

    Reminders for Quarterly Tasks

    Hi all, At work we have to complete a certain task quarterly for one type of client (let's call them Type Q) and semiannually for another type of client (Type S). I'd like the cell in column C to highlight to remind me if the current quarter (for Type Q clients) or current half-year (for Type...
  2. A

    Networkdays by quarter and holidays

    Hi everyone, I have calculated the total number of workdays between two dates by quarter using the formula below: =MAX(0,NETWORKDAYS(MAX($A2,C$1),MIN($B2,EOMONTH(C$1,2)))) Example: Start Date End Date 1/1/2019 4/1/2019 7/1/2019 10/1/2019 1/1/2019 4/30/2019 64 22 0 0 1/1/2019 12/31/2019...
  3. J

    Calculate number columns (quarters) that takes a value to change from - to +

    Hello guys, This query is quite specific to a model I'm putting in place but I hope you can provide me with a solution to make it work. With the table below, I'm trying to come up with a formula that gives me the avg number of quarters that takes a balance to switch from negative to positive...
  4. 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>...
  5. Leicester City Fox

    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...
  6. 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...
  7. 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)...
  8. 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...
  9. 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...
  10. 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...
  11. 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.
  12. 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 ....
  13. 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...
  14. 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...
  15. 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...
  16. 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 % =...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back