drewszone32
Member
I have below formula in which I believe it will take a point of after 181 days. So basically if someone got a point on January 2nd the point should come off July 3rd correct? I don't see the points coming off. Can anyone help.
=IF(MIN(SUMIFS(H2:NH2,$H$1:$NH$1,">="&EDATE(TODAY(),-181),H2:NH2,"<="&TODAY()))=0,"",MIN(SUMIFS(H2:NH2,$H$1:$NH$1,">="&EDATE(TODAY(),-181),H2:NH2,"<="&TODAY())))
=IF(MIN(SUMIFS(H2:NH2,$H$1:$NH$1,">="&EDATE(TODAY(),-181),H2:NH2,"<="&TODAY()))=0,"",MIN(SUMIFS(H2:NH2,$H$1:$NH$1,">="&EDATE(TODAY(),-181),H2:NH2,"<="&TODAY())))