Converting inputted Date Range into new monthly module

edited November 2022 in Modeling

Hey all, 


I need some advice here. I have a module (no time scale) where one of the attributes of a project is the start and end date (manual input as a date). I want to populate a new module (monthly time scale) with a 1 for each month the project will be active. Any recommendations on a formula to use to do this?


Example: Project A runs from 1/1/2022 till 3/1/2023. In the new module I would like to see a '1' under each month for that date range and a '0' for any months not in the date range.


Also any additional line items I'm missing for this logic to work?


Best Answer