Date formula help please

Hello the community,

my table has a list of projects (one line per project) with monthly income and a number of months, thus calculating the yearly income per project (one column for monthly amount and one column for number of months) and per year if i sum all the lines.

i am trying to create a view so I can visualize (in a dashboard) my forecasted revenue per month that includes all projects. The problem is that my table does not provide in which specific months the monthly revenue applies.

I also have a column with project start date and a column with project end date but I am not sure how i can use it to capture a monthly revenue per project.

i hope my explanation is clear enough.

Thank you in advance for your help!

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.