Excel date formulas using start and end dates

Occasional Contributor

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!

1 Reply



You haven't mentioned what type of impact you're trying to calculate. A hypothetical example would be helpful.