Forum Discussion
Trying to populate monthly data based on a start and end date of a project.
Hi All,
Am trying to populate monthly data, for a number of projects which have different start & end dates.
The monthly data the revenue expected for each month. This is calculated by looking...
Hi Neale Forth
I hope I have understood right. Please see the attached file to see if what I have interpreted is correct?
Cheers
Damien
Hi Damien.
Many thanks for your reply.
Apologies but I have not explained the problem very well !
Your solution populates the months for each project however its not synchronised with the project start & end dates. So in my example , first row/ project, starts in March 17. So for the first project, Jan 17 and Feb 17 columns would be zero however March 17 would look up the 0.15%....... does that make sense ?
Many thanks for your time/effort,
Neale
- Hi Neale
I get it now. I will need to think about it as I don't know of a solution off the top of my head. Hopefully some of the other skilled community members will have some ideas!
Will let you know if I come up with anything.
Cheers
Damien
