This is my first attempt at posting in Wodody's Lounge, so here goes...I'm looking for a way to extract monthly budget forecast information from my project plan. I'm aware that this can be done via a crosstab report or an analysis of timescaled data in Excel. However, the difficulty I'm having is with the customization of the output to reflect the way my company requires budget forecasting be done. We use the 5/4/4 fiscal month methodology, which means that if month 1 is a 5-week month, then months 2 and 3 would be 4-week months, month 4 would be a 5-week month, and so on. For example, the fiscal month of March began on 2/24 and ended on 3/30. Does anyone know a way to extract the data based on a customized calendar?
Thanks so much,