| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Quarterly Formula
Thank you very much JLatham!
-- Carol "JLatham" wrote: First hit on web search: http://www.exceltip.com/st/Calculati..._Year/932.html quarter based on calendar year (with date in A2) =INT((MONTH(A2)-1)/3)+1 quarter based on FY starting in September, again w/date in A2: =MOD(CEILING(22+MONTH(A2)-9-1,3)/3,4)+1 "Caroline" wrote: Is there a formula to obtain a total for each quarter which excludes including the year? Thus avoiding having to change to year on a yearly basis. Your help would be appreciated. -- Carol |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simplify formula using quarterly investment returns | Excel Worksheet Functions | |||
| is there a formula for quarterly expenses in Excel? | Excel Worksheet Functions | |||
| Formula Help to Calculate Quarterly Results | Excel Discussion (Misc queries) | |||
| How to calculate quarterly | New Users to Excel | |||
| Quarterly tax percentages | Excel Worksheet Functions | |||
Threaded Mode
