Forum Discussion
Modifying formula based on Date and time
Dear All, Please modify the highlighted bold formula that gives the result in such a way. =SUM(COUNTIFS(RM!$F:$F,$D25,RM!$H:$H,{"COMP","CLOSE","WCLOSE"},RM!$I:$I,">="&DATE(2018,12,1),RM!$I:$I,"<...
Hi Abdul,
You may add TIME to calculations like
(DATE(2018,12,1)+TIME(0,59,59)) (EOMONTH(DATE(2018,12,1),0)+TIME(23,59,59))