MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Frank D'Alena on July 15, 2001 3:38 PM

I would like to know if you can find information between specific dates in excel(like monthly reports).

Thank you


Posted by Aladin Akyurek on July 15, 2001 4:03 PM


Since you titled the subject as counting, I conclude that you want to count occurrences of objects (like numbers or names) that fall between two criterion dates. In that case, the answer is yes. Do a find at this page for multiconditional count. You'll probably find the answer. If not, post your question with sample data along with expected result(s).

Hope this helps.