dates

Episode 542 – Shortcuts

               

Jonathan writes in to mention Ctrl+; enters today’s date. In Episode 542, I run through several of my favorite shortcut keys, including Show Formulas, Visible Cells Only, and more. 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(…)

Episode 524 – Final Saturday of Month

               

Ammar from Iran sends in a question about how to find the last Saturday of any given month. Episode 524 shows how to use a couple of analysis toolpak functions to solve this problem. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every(…)

Episode 507 – JanFebMar Conversion

               

Your crazy software exported a file where the date column has the not-so-useful values like “Jan”, “Feb”, and “Dec” in a column. Episode 507 looks at a function to convert those values to real dates. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video(…)

Episode 494 – Time Stripping

               

Jonathan from California has a column with date & time information, but would like to strip out just the times to do an analysis by hour. Episode 494 shows you two formulas that can be used to analyze the data by hour. This blog is the video podcast companion to the book, Learn Excel from(…)

Episode 489 – Non-Sorting Dates

               

Viewer George sends in a column of dates that refuses to be sorted. George says that he already tried converting the text dates to dates using the text to columns trick. In Episode 489, we’ll take a look at two methods to tell if your dates are really dates and how to convert them to(…)

Learn Excel from MrExcel