Couldn't find a forum on this site for google sheets, so posting in here instead.
I am trying to create a cashflow forecast, using an if formula to test what the day of the month is, and use this to allocate a particular cost/revenue to a column relative to that week.
Basically:
If (day of...