Excel date formulas using start and end dates

%3CLINGO-SUB%20id%3D%22lingo-sub-2209255%22%20slang%3D%22en-US%22%3EExcel%20date%20formulas%20using%20start%20and%20end%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2209255%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20thought%20i%20had%20posted%20this%20question%20but%20can't%20find%20it%20so%20here%20goes%20again%20%3B)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20write%20a%20formula%20to%20get%20the%20impact%20of%20a%20contract%20in%20the%20current%20year.%20Example%2C%20contract%20is%20%241500%20with%20a%20start%20date%20of%2015%2F03%2F21%20until%2014%2F03%2F22.%20I%20need%20to%20calculate%20the%20impact%20of%20the%20contract%20in%202021%20(15%2F03%2F21%20-31%2F12%2F2021).%20I%20also%20have%20instances%20where%20I%20have%20contracts%20that%20run%20over%20several%20years.%20Example%20%246700%26nbsp%3B%20from%2001%2F04%2F21%20-%2031%2F03%2F23.%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20please%20help%20me%3F%20It%20will%20make%20my%20life%20soooo%20much%20easier.%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20input!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2209255%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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!

0 Replies