Extracting Days included within date range

[brncfan7]

I have a set of tasks that occur at different times throughout the year. The tasks all have a set start and end date, and I have to run reports at any given time. For example in the month of July, I have to report on the tasks that occurred in July; said tasks may have a start date in April and run through November, but I have to report on the portion of the task that occurred in July.

I am struggling to come up with a valid formula that gives me the number of days that a task occurred in a month (this drives my reports), particularly when the task may not start/end in the month I am reporting on. I have attached a sample data set - I would need to return the number of days that the task occurs in the reporting period in column "I" which I have highlighted. I can't seem to reconcile the start/end dates of tasks and how they fit into my reporting period in columns A-C. Any help would be greatly appreciated!!

[63falcondude]

I'm not sure if my logic is correct here but maybe something along the lines of this:

=MIN(B$3,G3)-MAX(A$3,F3)

[brncfan7]

That does part of it, but when a task doesn't start in that date range or has already ended prior to the reporting period beginning, it returns negative numbers.

[sourabhg98]

Improving upon @63falcondude 's solution-

Please Login or Register  to view this content.

This should deal with negatives.

[brncfan7]

Improving upon @63falcondude 's solution-

Please Login or Register  to view this content.

This should deal with negatives.

That did it - thank you!