Forum Discussion
Monthy budget planner starting on 15th...?
Hi SnowMan55,
Thank you for your reply and solution. I have changed the date a few times and so far it works 100% as I wanted it to.
I’ll be 100% honest and admit I’ve spent quite a bit of my time looking at the formulas and the example and I don’t understand what it is doing – I think a fair bit of reading on my part is required!
I love it! Thank you so much for taking the time to work this out.
As a matter of interest, this solution you have provided, would it fall under basic, intermediate, advanced for expert level of excel? (I’m only asking so as I can work out where I’ll need to start learning and where I’ll need to get to.)
Many thanks to you and to the fantastic community of avid spreadsheet users in this community. I posted in another forum asking for this before this one, so I will link this solution to it so that the way to achieve this becomes more widely available to as many as who need it.
Wavey75
This solution would I suppose be considered an intermediate level of complexity. The IFS function is not commonly used, and the LET function is fairly new.
The important part is understanding the main cell formulas. To make it easier for you, I have added descriptive text in that regard into column C on the _Info worksheet.
I added a bonus column on the Example worksheet, and have added links to information about conditional formatting and custom number formats at the bottom of the _Info sheet.