Date Formula Help Please!

[punukollu]

Hello, I am looking for a formula with the following conditions:

• 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

Task:
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.

 

[punukollu]

Hey,

Any possibility that you can email me the spreadsheet to punukollu50@yahoo.com

Much appreciated.

Thank you.

 

[punukollu]

Good Morning,

I am at working at trying the formula....

I guess I am doing something wrong. Not able to come up with the solution as you recommended.

Please help...