Hello, I am looking for a formula with the following conditions:
I need a formula where I can say - count the total number of projects from period 01 to Period 13 with the period end date restrictions for the fiscal year. The formula should be able to count the no of projects for each period individually.
Thank you very much for your help.
- The fiscal year of the business runs from December 30, 2007 to January 03, 2009
- There are 13 periods in the fiscal year ending with different date ranges. For example, period 01 runs between December 30, 2007 to January 26, 2008
- There may be 3 capital projects completed in Period 01, 5 in period 02, 6 in period 03 and so on
I need a formula where I can say - count the total number of projects from period 01 to Period 13 with the period end date restrictions for the fiscal year. The formula should be able to count the no of projects for each period individually.
Thank you very much for your help.