Ok here’s my proposed solution.
From the array, use this to get the array length.
Use this to calculate the date difference between the start date and now: TRUNC(N-D)
Use this to calculate the index of the “current day”: MAX(MOD(D,C),0)
And finally this to get the number of the day via the index.
