dates

Episode 480 – Text Dates

               

After importing data, your numbers and dates might be stored as text. While newer versions of Excel allow you to solve the numbers stored as text easily, the exclamation point dropdown never appears for the dates stored as text. Episode 480 takes a look at several methods for solving the problem. This blog is the(…)

Episode 447 – Dates as Numbers

               

Here is a bizarre problem sent in by a viewer. Many of you will think that you know the answer, but this problem is not as simple as it appears. In a worksheet, any dates are instantly converted to their 5 digit serial number. The actual date is shown in the formula bar, but the(…)

Episode 440 – Virtual AutoFilters

               

Excel 2007 does offer a number of improvements in the AutoFilter arena. Episode 440 shows the new virtual date filters, such as selecting records from this week, next month, or last quarter. This blog is the video netcast companion to the new book, Excel 2007 Miracles Made Easy. Download a new two minute video every(…)

Episode 431- Fill Weekdays

               

If you work Monday through Friday, Microsoft has a great secret shortcut for filling all of the weekdays in your spreadsheet. Episode 431 shows you how. 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 the 277 tips(…)

Episode 414 – Joining Dates

               

If you try to use the concatenation character to join text with a date, you will not get the results that you expected. Episode 414 shows you how to modify the formula to properly format the date. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two(…)

Learn Excel from MrExcel