I am looking to make a budget spreadsheet that lets me see when money has been spent but is also committed. I have managed to get a Sumif column to work out if money has been allocated within a certain time but I would like it to do more if possible. I cannot seem to get a formula that works so any advice would be welcome.
Basically, I want it to do two things in the committed spend box:
1- check if the money has been committed within the year e.g. 1/04/19 -31/03/20,
2- then check if it has been paid out by looking at the paid column.