Creating a Master Calendar that aligns with internal data
Hi,
I am creating an app for our sales team to be able to view sales data by different time periods. Our internal data is able to show Week, Quarter and Year. For some reason, our database does not have a month column. What would be the best way for me to add the months of the year based on a 4-4-5 calendar technique?
Note: 4-4-5 calendar refers to each quarter of the year being broken up into equal time periods. Because of this months do not align with the 1st to 31st that our standard calendar has. The first 2 months in a quarter are specified by 4 weeks each where the final month in the quarter contains 5 weeks. (Example: January starts on 12/27/2015 and ends on 1/23/2016. This represents Weeks 1,2,3 and 4. February starts on 1/24/2016 and runs until 2/20/2016 based on the 4-4-5 calendar. This represents weeks 5,6,7 and 8. March starts on 2/21/2016 and ends on 3/26/2016. This represents the final month of Quarter 1 and includes Weeks 9,10,11,12 and 13.)
