dates

Timestamp – 1106 – Learn Excel from MrExcel Podcast

               

David from Australia sends in a cool trick for adding a timestamp to a spreadsheet. Episode 1106 shows you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Blank Row for Missing Dates – 1103 – Learn Excel from MrExcel

               

Sam from Vienna sends in today’s question. In a database of events, how can he add new blank rows to represent every missing day? Episode 1103 shows you one method. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn(…)

Dueling: Random Date – 1095 – Learn Excel from MrExcel Podcast

               

Mike and Bill offer different ways of generating a random date between two dates. Episode 1095 shows you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Quarters or Weeks – 1074 – Learn Excel from MrExcel Podcast

               

LearnAccessByCrystal sends in a cool tip that will allow you to format dates to show quarters, weeks, and more. Episode 1074 shows you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from(…)

Fiscal Quarter UDF – 1033 – Learn Excel from MrExcel Podcast

               

If your fiscal year does not end on December 31, then all of the cool date grouping functions available in pivot tables will not work for you. In Episode 1033, you will see how to add a couple of user-defined functions to your personal macro workbook to simplify the conversion of date to Fiscal Quarter(…)

Learn Excel from MrExcel