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 expected cost) is greater or equal to the start day of the current week, but less than the start day of the next week, allocate cost to current week, or leave blank.
This works fine throughout the month, but at month end I have an issue as the start day of the next week, say 6th (6) is less than the start of this week, say 29th (29). Causing the formula to return nothing.
Best described with an example: Month end date issue
Can anyone tell me the correct formula to use to make this work please?
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 expected cost) is greater or equal to the start day of the current week, but less than the start day of the next week, allocate cost to current week, or leave blank.
This works fine throughout the month, but at month end I have an issue as the start day of the next week, say 6th (6) is less than the start of this week, say 29th (29). Causing the formula to return nothing.
Best described with an example: Month end date issue
Can anyone tell me the correct formula to use to make this work please?