21
Nov 2013
- BY Kevin Lehrbass
- POSTED IN Formulas
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
We can use Excel’s MIN function to find the minimum number in a range. As date values are technically numbers, the MIN function can show the oldest date.
But….how can you find the Monday before the oldest date???
Watch my YouTube video
A relatively easy formula provides the answer.