Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.templates,microsoft.public.excel.worksheet.functions

Ola[_5_]

external usenet poster

Posts: 7

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
quarterly reports	Ola	Excel Discussion (Misc queries)	0	February 13th 05 12:39 AM
quarterly reports	Ola	Excel Worksheet Functions	0	February 13th 05 12:39 AM
quarterly reports	JulieD	Excel Programming	1	February 12th 05 03:29 AM
quarterly reports	Jim Thomlinson	Excel Worksheet Functions	0	February 11th 05 12:05 AM
quarterly reports	David	Excel Worksheet Functions	0	February 11th 05 12:01 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us