Forum Discussion
Solved
SUMPRODUCT with Text
Hi all, I am trying to write an equation that will count every instance two dates are more than 30 days apart. The spreadsheet is a living and growing document so having open ranges would be preferr...
I had to make a slight tweak since I had written my formula wrong. It should have been, SUMPRODUCT if B2:B5-30>A2:A5. Basically if the dates in column B are more than 30 days past the dates in column A, count it. I used your formula but just changed those ranges and it's perfect. Thank you!
You are welcome.
Actually an error is in this part B2:B5-30 if text appears instead of number, IFERROR fixes that.