Equity drawdown recovery

Hi, in ref to the attached excel, I am looking for a formula to calculate recovery time for multiple drawdowns in a time series (draw length). Recovery time refers to the time a value takes to return to its previous peak. The point to be noted here is that - since the trading dates are specific, the no. of days that would be the outcome for this would be calendar days and not trading days.

I have already applied a formula in the attached excel from another thread (formula suggested by Bernie Deitrick) to calculate the draw length, but that takes into account the trading days and not calendar days.

Thanks!


Forum post - Draw size and length..xlsx