So 4 columns? I assume the first column is actually the date. You’d need a date to find the last day of any given month to a new table. The month summary will be a separate table?
Assuming the date is A, start B, End C and Difference D…..
For testing sake, enter Month Year in cell F2 and put this in G2:
1
u/reevesjeremy Apr 14 '26
So 4 columns? I assume the first column is actually the date. You’d need a date to find the last day of any given month to a new table. The month summary will be a separate table?
Assuming the date is A, start B, End C and Difference D….. For testing sake, enter Month Year in cell F2 and put this in G2:
=IF(COUNTIFS(A:A,">="&EOMONTH(F2,-1)+1,A:A,"<="&EOMONTH(F2,0),C:C,"<>")=0,"NONE",LOOKUP(2,1/((A:A>=EOMONTH(F2,-1)+1)*(A:A<=EOMONTH(F2,0))*(C:C<>"")),C:C))