benicholson100
New Member
- Joined
- Dec 5, 2019
- Messages
- 6
- Platform
- Windows
Hi guys,
I am trying to populate cash outflows based on payment date of month (ie 1st, 10th in column G) to weeks (ie week commencing 27th April - always a Monday - in Row 7).
The below image shows my formula works for everything but 1st of the month where the week commencing crosses over a month (e.g. 27th April and 27th July but populates 1st June).
Can anyone help find a way around this?
Many thanks
Ben
I am trying to populate cash outflows based on payment date of month (ie 1st, 10th in column G) to weeks (ie week commencing 27th April - always a Monday - in Row 7).
The below image shows my formula works for everything but 1st of the month where the week commencing crosses over a month (e.g. 27th April and 27th July but populates 1st June).
Can anyone help find a way around this?
Many thanks
Ben