Automatic Calculations based on Current Month

[yagu99]

I have a spreadsheet that I would like to automatically update cell values based on the current month and my data would have to be for that month. The spreadsheet has all the data in it (which could be from other months / years. I only want it to start calculating based on the current month going forward & continue to do this automation.

Any help will be greatly appreciated

Thanks,
yagu99

I would like the Jun-11 section (below) to update Cat1 numbers and Cat2 numbers only for the Jun dates listed within the sample file Cases 1-6 and continue as more cases are added including additional months (e.g. July, Aug, etc..) Hope this makes sense...

Sample File:
Case # Status Open Date Cat 1 Cat 2

1 OPEN 23 Jun 2011 12:45:11 GMT test1 test3
2 OPEN 22 Jun 2011 12:45:11 GMT test2 test4
3 OPEN 22 Jun 2010 12:45:11 GMT test2 test3
4 CLOSED 23 Apr 2011 12:45:11 GMT test2 test4
5 CLOSED 23 May 2011 12:45:11 GMT test1 test4
6 OPEN 12 Jun 2011 12:45:11 GMT test1 test3


Jun-11
Cat 1 Cat 2 OPENED CLOSED
test1 2 test3 3 4 0
test2 2 test4 1


May-11
Cat 1 Cat 2 OPENED CLOSED
test1 1 test3 0 1 1
test2 0 test4 1


Apr-11
Cat 1 Cat 2 OPENED CLOSED
test1 0 test3 0 1 1
test2 1 test4 1

 

[pbornemeier]

1) The case numbers do not appear on the Monthly reports. I believe they should.
2) It is not clear where the single digits in the monthly reports come from.
3) Are the monthly reports to be generated
.. a) Below the Sample File Data?
.. b) All on a separate worksheet?
.. c) Each month on a separate worksheet?
4) What happens if a test is open in one month and closed in another - which month should that appear in?
5) Please show a complete set of a few OPENS and CLOSES for a set of entries and the desired resulting Monthly reports. See Excel Jeanie link in my sig.