ContributionsMost RecentMost LikesSolutionsRe: How many projects are active in a given month?Ok, so this is working now! So I guess I'll need to change field names each month as it goes by? Now, I'm trying to make a report (summary I believe) to show the totals for each month. Any guidance here? Thanks! Matthew Re: How many projects are active in a given month?I made a field for November. The formula seems to result in "1" no matter of the start date. Can you review the formula below and let me know what I'm missing? Also, what number do I adjust to be the next month's field? Does it reset in Jan? var date ActiveMonthStart = FirstDayOfMonth(AdjustMonth(Today(),2)); var date ActiveMonthEnd = FirstDayOfMonth(AdjustMonth(Today(),2)); If( [Est Installation Start Date]<= $ActiveMonthEnd and [Est Completion Date] >= $ActiveMonthStart,1,0) Re: How many projects are active in a given month?Thanks for your reply. I basically understand what your describing here as a solution, but I think it may be a bit advanced for what I can do. I'm not sure of all the field types or how many fields this would take to create. Is there a simpler way? - MatthewHow many projects are active in a given month?I have about 50 or so active projects that span over several months, some are wrapping up, others are starting up. I've added start and end dates, but I cant seem to figure out how to calculate how many projects will be active in a given month. I want to be able to forecast how many active projects I will have in each month moving forward.