=Max(A1:A27). Yeah, but what I'm looking for is actually "=max(since previous peak)".I know, the strict definition is " max(from beginning of time : now)" --- but nobody actually USES it that way. In usage, everybody treats it as the most recent peak. Nobody cares about a drawdown from a peak that happened 50 years ago. They care about the peak that happened in the last few years or less. Heck, the thing that most people only look at is the current price vs. the 52-week high.Or maybe I'm overthinking it. Anyway, 12-month drawdown is Good Enough for my purposes. The bear markets of 2001 & 2008 kinda swamp out any older peaks.The other drawdown that I personally look at is "drawdown since Sept 2006 when I walked out the door and retired early".