Learn Excel Episode 540: DATE EXTRADONAIRE
I love the DATE function. While some Excel functions are rather picky, the DATE function can handle just about anything that you throw at it. Want to know the 35th day of January? No problem. Want to know the 17th month of 2008? Easy. Want to know why this matters? Well, watch Episode 540 for a cool trick with the DATE function.