Quote:
Originally Posted by Excel Dumbo
Thanks a lot Omen for the detialed explaintion. Works well and made my life easy. Hats off to you
Hello Spencer, thank you very much for pointing me to the right direction for the Quarterly data . If you could mock up a version for me, that would be extremely great.example workbook is in exact layout and unfortunately I am using Excel 2003 version.
Awaiting your solution to the quarterly problem.
|
A couple of questions:
1) Do you have the analysis toolpak addin installed on your machine?
Easy way to tell is format two cells (A1 & B1) in a new workbook at DD/MM/YYYY dates). In A1 type today's date and in B1 type =EOMONTH(A1,0) and press enter. If the date shown in B1 is the last day of the month, then you have the toolpak installed and that makes life easy. If you get an error then you don't have it installed.
2) What happens when the date selected gets to November for example? Should it just say Nov & Dec or should it be Nov, Dec and Jan of the following year?