How To Collect Data based on date and post to proper month column
I have a several large projects running in a portfolio. The projects are all construction in nature and with each project there are subsections of construction each with target completion footage and target completion dates.
I would like to build a report to show me the total build footage across the various projects by month based on the project dates (task end dates).
Build activity #1 1/1/22 - 3/1/22 100 feet
Build activity #2 3/2/22 - 4/1/22 200 feet
Build activity #1 1/1/22 - 3/1/22 50 feet
Build activity #2 3/2/22 - 4/15/22 75 feet
Is there a formula that i can use to reference the task completion date of say 3/1/22 and would thus put the 100 in the Mar column? Then if those dates get changed to day 6/8/22, auto update the above example and show the 100 items in the Jun column?
Thanks in advance for any guidance! I struggle with formulas.
Help Article Resources
Check out the Formula Handbook template!