Excel magicians,
I am using this formula in cell S9: =COUNTIFS(H:H,">="&DATE(2012,10,1),H:H,"<="&DATE(2012,12,31))
to count the number within these dates (due dates) and is working nicely. My problem is adding on to it. I need a formula in cell T9 that would count if there is a date in column I ONLY if it falls within the dates in the previous formula. Lastly a formula in cell T9 that would give me a count of the completed (column I) that is mor than 95 day beyond the dates in the original formula. Hope I explained it well enough. Thanks in advance.
Bookmarks