Avatar of tawathav

asked on 

Need help with Excel formula


I have the following worksheet attached with the following fields.

Tracking ID
Project date
Project value
Project Length

I am trying to come up with a formula to calculate project value by how long the project is. For example if the project date is 1/1/2014, the project was for 2 years, and valued at $100, the project value by year would be $50 in 2014 and $50 in 2015.

See attached file.
Microsoft ExcelMicrosoft ApplicationsMicrosoft Office

Avatar of undefined
Last Comment
barry houdini

8/22/2022 - Mon