-I want to compare the start/end dates to each cell C2:P2, and if the dates occur there return a true.
-I want to return a True (1), False (0) for each cell in row C2:P2 (yellow) in C3:P3 I will have the following formula to distribute dollars evenly along the "true" cells
-My problem is b/c of the start/end dates I cannot find a formula that will give the true/fasle results for
ALL dates in the range between start/end and allow for the formula to carry over across years.
-The formula I found that MOST closely works the way I want it to is below, but it falls apart at end of years and when crossing over years as it only compares the # value of the month.
=IF(AND(MONTH($G7)<=MONTH(I4),MONTH($H7)>=MONTH(J4)-1),1,0)
Bookmarks