counting notes made after a date

[revlinda820]

Hi i am trying to create a tracking sheet for my coworkers and myself to trach our new contract expectations. I have listed in the table the dates we enrolled out clients and the dates we did a plan on them. i need to be able to count:

1. the number of contacts we had after we enrolled them in a second part of the program
2. the number of contacts we had after doing a plan.

the table has these columns as well as others

WIPA enrolled Date WIP date contact date contact date contacgt date etc..

the columns i need help on are
#of contacgts after WIPA enrollment and # of contacts after WIP

 

[Joe4]

Welcome to the Board!

I am thinking you may be able to use formulas like COUNTIF, COUNTIFS (if you have Excel 2007 or later), or SUMPRODUCT to do what you need. Take a look at those functions in Excel's built-in help files.

If you cannot figure it out, we can probably help you construct your formula, but will probably need to see a sampling of what you data looks like and what your expected results are.

There are tools you can use to post screen images, found here: http://www.mrexcel.com/forum/showthread.php?t=508133