So I am trying to create a formula in excel that is based off of a
start and end date.

It's probably fairly simplistic, but I am missing sme component
somewhere to finish this.

In short, I want to look at the start and end date of multiple
projects. If the it falls within the date range I would return a value
of "A" for active or if it doesn't I would return a value of "I" for
inactive.

I have about 80 projects running and I want to show a forecast of what
projects will be running each month and what won't based on start and
end dates.

Has anyone done something similar to this?

Thank you so much in advance.

Rob