That is not easily one as in a summary report, a record may only appear once. There is a way to do this for a start and end date to see which projects were active between those dates.
But if you needed to have that on a single summary report by month hen you would need to set up an automate process to ensure that each project had say 12 Project Month children (assuming that a project would not go more than 12 months), and then use the child table or Project Months for your summary report. The child records would take the date by formula based on the lookups of the start and end date of the project and say Child #3 would calculate if it was active in the third month after the start date and what month that was.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
