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.