Formula to count based on a date Range
Im trying to write a formula that counts each month based on a date range so that a number is attached to each month within the date range.
ie, If an activity starts 04/01/24 and ends 08/01/24, I need to add "1" to each month in Between so the formula would reflect activites per month between start and end date. Attached is my data sheet and i am trying to populate the Sum column.
Thank you to anyone in advance who can help!
Help Article Resources
Check out the Formula Handbook template!