Today, Nick asks how to get the word ‘August’ in cell B1 from a date in cell A1. In Episode #1414, Bill shows us how to convert a date to a month name or to a weekday name using the TEXT function.
…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!
“The Learn Excel from MrExcel Podcast Series”
MrExcel.com — Your One Stop for Excel Tips and Solutions