Please see attached spreadsheet.
I am having trouble figuring out why the formula on the 'UCA Summary Data' tab for the "Definitized in FY10" chart does not work for the month of January. I am simply trying to count the number of items that were definitized this month, but it works for every othe month but January.
I also have another problem with the 'UCA Summary Data' tab. The formulas I have in the "Overage in FY10" and "Overage in FY11" charts seems to miss counting items that become overage at the beginning of each month or at the end of the fiscal year. Can anyone help me with either/both issues?
Bookmarks