Fri, 10 December 2010
Todays Dueling Excel Podcast, Episode #1303 with Mike "Excel Is Fun" Girvin and Bill "MrExcel" Jelen, looks at 'Unwinding Dates'. Suppose your dates are input like this: "1997-1999" How can you have each date year list out so that they now appear as sequential: "1997 1998 1999"? You may choose to use Excel VBA [Visual Basic for Applications] or Formulas...but in any event you'll want to watch Episode #1303 to see how its done! …This episode is the video podcast companion to the book, “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel. For all of your Microsoft Excel needs visit MrExcel.com - Your One Stop for Excel Tips and Solutions. |
Bill Jelen

