Use SUMPRODUCT:
=SUMPRODUCT(((WEEKDAY(TODAY())>= 3)*(WEEKDAY(TODAY())<=6)*(INT(AG10:AG100)=INT(TODAY()-1)))+((WEEKDAY(TODAY())=2)*(INT(AG10:AG100)>=INT(TODAY()-3))*(INT(AG10:AG100)<=INT(TODAY()-1))))
If the Dates in AG ...READ MORE
Nov 26, 2022
in Others
by
narikkadan
• 63,600 points
•
639 views