quarters

  1. K

    Moving Dates in quarters

    hi, Just need a bit of help with some data for over due invoices. for example the data will look like <colgroup><col><col span="3"><col span="4"><col><col span="2"></colgroup><tbody> Date Balance Current P1 P2 P3 P4 Older Due Date Payment Terms Days Overdue 19/09/2017 2,160.00...
  2. G

    Select Quarter for COUNTIFS

    My database has a column for initial date from which Iidentify the YEAR and QUARTER. I use the COUNTIFS function where one criteriais QUARTER and the range is 3 for Q3. IfI want to look at the data for another QUARTER like Q1 to Q3, I have to changethe range to =<3. The report has over30...
  3. S

    Count cells corresponding with quarter 1, 2, 3 and 4 without getting a #VALUE! error on blank cells.

    I'm at large here.. Must have spent more than a whole day searching the internet and trying all sorts of solutions.. to no result.. :confused: I try to make a spreadsheet that calculates what I've spent per yearly quarter, from a whole column of dates and spendings. There are some blank cells...
  4. J

    Averages from quarterly amounts

    I'm struggling with a formula that will provide an average from quarters of data. Example: Row 1 I need the 6 month average of the first two quarters. When data is added to the third quarter the average needs to change to a 9 month average. Example: Row 2 Also if I have data in the 1st and...
  5. J

    Splitting data in yearly quarters

    Hi, I have a large data set which include a date on each line. This ranges back to 2009. I need a formula which can identify which quarter each line fits into ie: date is 1/12/2011 - should read 'Q4 2011' I have come up with a long winded formula of...

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
Back
Top