check if a payment is weekly or monthly, then check dates, if payment is due on, within 1 week before week ending then add value. if not then add nothing.
B34 is stating whether weekly or monthy, B10 & 11is the check, e34 is the value. C34 F12 & G12 are date ranges
=if(weekly=weekly,$,if(and(monthly=monthly,due date>=1st week ending - 7 days,$,and(due date>1st week ending<2nd week ending,'""
I'm getting "Value" instead of "" or $
Solved by D. E. in 13 mins