Mar 14 2021 11:21 AM
Hi everyone,
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.
Thanks for your input!
Jan 17 2022 09:31 AM
You haven't mentioned what type of impact you're trying to calculate. A hypothetical example would be helpful.
David