dates

Episode 688 – Month End

               

Calculate the last day of this month, using a new trick sent in by Bob. Episode 688 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!

Episode 592 – Missing Pivot Dates

               

Today’s question is a follow-up to yesterday’s question. How can you make sure that a pivot table shows you one row per day, even if there were no sales on a given day? Episode 592 shows two annoying solutions. If you have a better solution, please send in your ideas to bill @ MrExcel.com. This(…)

Episode 591 – Missing Dates

               

When you create a chart from data that might have missing dates, you might want Excel to plot the missing dates along the horizontal axis. In Episode 591, we take a look at why Excel sometimes chooses to use a time scale and sometimes does not. This blog is the video podcast companion to the(…)

Episode 559 – Zeroth Day

               

Erik points out that the best way to find the last day of this month is to ask for the zeroth day of next month. Episode 559 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(…)

Episode 551 – Red-Flag Dates

               

Van writes in with a suggestion about podcast 539. In that podcast, we were trying to calculate which customers had their birthday coming up soon. Van suggests using conditional formatting and the TODAY() function to flag the customers to whom you need to send birthday cards. Episode 551 shows you how. This blog is the(…)

Learn Excel from MrExcel