Spend profile

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I am trying to spread a value over a date range (spend profile).

Esentially

Col A = Start Date of an Activity
Col B = End Date of an Activity
Col C = Value to replicate across Col D, E, F etc

The value replicated must fit within the date range of Col A and Col B. So the respective columns D, E etc are example 01/01/10, 02/01/10 etc

What is the best way to go about this?


1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
What did you meant by "Col C = Value to replicate across Col D, E, F etc "

Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too