I need to solve one issue. I've created database, which contain column with Dates(column E),and column with Action's duration in days(column F)[This column also contains blank cells or cells with "NFF" because actions didn't actually append or other reasons...]. I've been trying for long but cannot come with any formula, which will count Actions(column F) occurred in ONE-certain month , moreover, i wish only those values be counted which duration is equal 2 or less. In the end, I expect outcome in column J, where I want have amount of actions (finished within 2days) for each month.
I prepared simple example, accordingly to description.
I need formula for column J - for each month, cells are marked with red question marks.
PS: Formula array should probably include all the dates and values, because values and dates can change and will be added by users, so formula have to work independently from entries order or so.
Thank you in advance, and looking forward for some answers.
Counting action under condition of theyr value, and month when..
I am sorry but i probably was not clear enough, excuse my English please. I need to get number of actions, which have been done in two days, which mean 0,1 and finally 2 in column F. I am attaching another link with same example,but now it contains written results which should be outcome of the formula. Thank you for patience :)