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...

Some videos you may like

This Week's Hot Topics