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.

 

Subscribe to my YouTube channel and learn more!

See my free templates here!

Post a comment