A great question from one of my Excel seminars started out as a simplequestion: how can I convert a column of dates to show if the day isMonday, Tuesday, etc.? However, upon further examination, they weretrying to figure out the banking day before the date shown. This couldhave been an ugly combination of IF functions to locate Mondays and BankHolidays. However, one obscure function solves this problem in a shortformula.
Episode 644 shows you how.
This blog is the video podcast companion to the book,
Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
More...
11/05/08, 16:44:13
Episode 644 - Previous Banking Day 
Mode Lineal
