You may want to have both Open Date and Close Date as a single Date Dimension.
When connecting to Text / Excel, you can Pivot your Date columns into a single Dim.
After that, everything is straightforward -- using a Running Total Table Calculation.
Please find the attached as an example using Sample Superstore datasource.
Hope it could help.
Orders Shipped_YF.twbx 1.3 MB