Could you share your workbook?
No because of proprietary information, plus I connect to my data via ODS so you would not be able to see the data anyways.
I have two data-sets of the same information.
One data-set has a single row per task, with separate columns to record timestamps (opened, resolved, closed, etc.).
The other is a data-set I joined together to give me one line per task event - meaning that in this view each row is it's own action (having a single column to store the date and another column that identified the action (opened, closed, resolved, etc.)
And you also have another Date field to place in Columns, right?
If you have it like this in your data set:
Opened, Closed, Date (aka Reporting date)
10-10-2018, 11-04-2018, 10-01-2018
10-10-2018, 11-04-2018, 11-01-2018
10-10-2018, 11-04-2018, 12-01-2018
You may try this:
IF MONTH([Date]) <= MONTH([Closed]) and MONTH([Date]) >= MONTH([Opened]) then Active
and you'll get this:
Opened, Closed, Date, Status
10-10-2018, 11-04-2018, 10-01-2018, Active
10-10-2018, 11-04-2018, 11-01-2018, Active
10-10-2018, 11-04-2018, 12-01-2018, Inactive