| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quarterly Analysis in Excel
I am trying to create a quarter to quarter analysis. I am using the
following equation to create the quarter off a give date. ="Q"&INT((MONTH(A1)/4)+1)&"-"&RIGHT(YEAR(A1),2) Lets say for todays date that equation returns Q3 10. I want to make the next cell generate the following quarter, Q4 10 but cannot figure out the proper equation. Help! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Quarterly Analysis in Excel
On Oct 12, 11:27*am, JSRothbart wrote:
I am trying to create a quarter to quarter analysis. I am using the following equation to create the quarter off a give date. ="Q"&INT((MONTH(A1)/4)+1)&"-"&RIGHT(YEAR(A1),2) Lets say for todays date that equation returns Q3 10. I want to make the next cell generate the following quarter, Q4 10 but cannot figure out the proper equation. Help! ="Quarter "&=INT((MONTH(a1)-1)/3)+1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is there a formula for quarterly expenses in Excel? | Excel Worksheet Functions | |||
| Excel 2002 Analysis ToolPak Regression Analysis Help Requested | Excel Worksheet Functions | |||
| how to calculate quarterly compounded interest in ms excel | Excel Discussion (Misc queries) | |||
| How about adding a quarterly function to Excel like its EOMonth? | Excel Worksheet Functions | |||
| How do I graph a quarterly time-series in Excel? | Charts and Charting in Excel | |||
Hybrid Mode
