@HaniJamil - what i recommend that you do is break your logic down into two rules so that you eliminate the “or” condition.. that is what is throwing your logic off..
in your logic rule below, delete the OR condition. then recreate the same series of statements for all the logic except swap out the “from yesterday’ for the ‘in 1 month’ to make a second rule.
that should clear up your logic issue
combining the Boolean logic conditions does not work all the time.. i try to keep it clean with single flow..