ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   quarterly reports (https://www.excelbanter.com/excel-discussion-misc-queries/12883-re-quarterly-reports.html)

Ola

quarterly reports
 
Here are 2 pieces that might help:

1. Insert a New Column with Quarter (Col B)
Created from Week date: ="Q"&ROUNDUP(A2/13,0)
Created from Calender date: ="Q"&ROUND(MONTH(A2)/3,0)

2. Where col B is Q1, Sum every row in col C:
=SUMIF(B1:B52,"=Q1",C1:C52)

Ola Sandstrom


Note:
Quarter from weekdate will not entierly correct, as Jim points out.
Quarter from calendar date will be correct.


All times are GMT +1. The time now is 06:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com