josh121223
New Member
- Joined
- Mar 12, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
i have a problem if anyone could help it would be grateful i would like to find the drawdown duration in days example 1/24/2005-1/7/2005=17 days want a formula to calculate the days between how long the drawdown lasted and entry date is column A and drawdown is column B want answer in coulmn C
Entry date | drawdown | drawdown length in days | |||||||
1/2/2005 | 0% | ||||||||
1/7/2005 | -1% | ||||||||
1/15/2005 | -2% | ||||||||
1/24/2005 | 0% | ||||||||
2/3/2005 | -1% | ||||||||
2/10/2005 | 0% | ||||||||
2/14/2005 | 0% | ||||||||
2/20/2005 | -2% | ||||||||
2/28/2005 | 0% |