I thought i had posted this question but can't find it so here goes again ;)
I need to write a formula to get the impact of a contract in the current year. Example, contract is $1500 with a start date of 15/03/21 until 14/03/22. I need to calculate the impact of the contract in 2021 (15/03/21 -31/12/2021). I also have instances where I have contracts that run over several years. Example $6700 from 01/04/21 - 31/03/23.
Can someone please help me? It will make my life soooo much easier.