Hi Everyone,
I am new to this forum. Hope some one can help me out with my query.
I have a table as follow and need to count the entries automatically based on monthly
Column A Column B Column C Column D
Detailed Plan 05-Jan-2013 10-Jan-2013 +4
Detailed Plan & Estidama 05-Jan-2013 15-Jan-2013 -1
Detailed Plan 02-Feb-2013 20-Feb-2013 -9
Detailed Plan 02-Feb-2013 12-Feb-2013 -1
Detailed Plan & Estidama 09-Mar-2013 18-Mar-2013 0
Column A represents the document, Column B the document submitted date, Column C review completion date and column D measure the review time against 10 days KPI, it is within service level or not.
I need a formula to calculate the number of document submitted in jan , feb and march which is within KPI and without KPI.
Could someone help me out here?
Thanks,
Bookmarks