Excel 2007 : Counting the recovery time of multiple drawdowns

**spiros63** · 07-03-2012, 07:09 AM

Hi guys,

What I'm looking for is a formula which will count the recovery time (elapsed days) between high-new high.
Extented explanation you can find in the attached file and at the last post of this ---> http://www.excelforum.com/excel-general/690004-high-water-mark-draw-down-calculation.html?p=2844919#post2844919

Thanks in advance

**Marcol** · 07-03-2012, 08:25 AM

Not sure what you are trying to do, but at a guess try this ...
In E4

Please Login or Register  to view this content.

Drag/Fill down

**spiros63** · 07-03-2012, 09:54 AM

Well... that was close

Have a look at the re-uploaded file.
I prepared a sheet with your formula returns and the expected results beside, in red color, for comparison.
I hope that helps

**Marcol** · 07-03-2012, 11:18 AM

This will give you what you ask for ...
In E4

Please Login or Register  to view this content.

Drag/Fill Down

However I'm not convinced it's returning what you think it does.

**spiros63** · 07-03-2012, 12:03 PM

Yeap !!!

This is what I'm talking about.

Is this really your dog ?
Like father like son...

Be Cool.jpg

**spiros63** · 07-03-2012, 01:38 PM

Originally Posted by Marcol

This will give you what you ask for ...
In E4

Please Login or Register  to view this content.

Drag/Fill Down

However I'm not convinced it's returning what you think it does.

You make me worry,

Why you are not convinced that it is returning what I think it does ?
Should I try another approach ?

**spiros63** · 07-04-2012, 09:21 AM

Marcol

You were right !
The worksheet ended up a mess.
It was my mistake because I did it in parts.
Anyway, threw it out of the window and prepared a new one from scratch, without any formula in it.
If you want have a look at the new thread that I opened.

http://www.excelforum.com/excel-2007...very-time.html