I had this question after viewing Formula Date modification by Rongzo1971
please see attached file. this one looks a bit challenging. i tried a lot, could not figure out to add additional condition in SUMPRODUCT for second column date.
i need the formula in the yellow cells.
very much appreciate your help.
there was a typo in the F3 formula where at the end it had a double TT for the Left and i found it and fixed it. but your formula really amazed me. i could not decode it how it works. but it does the job very well.
is it possible to merge both of two different formulas together as one? like if i just paste one formula in F2 and drag down? if it is too much, then i can live with the one you already helped me with. it is already amazing ! i love it.