dates

ADM Calculation – 1133 – Learn Excel from MrExcel Podcast

               

Patricia called the other day with a problem which will be familiar to everyone who works in a public school district. The state pays the school for every student who is enrolled on the magic date of October 1. Given a start date and end date, how can you tell if the date is in(…)

Filling Quarters – 1132 – Learn Excel from MrExcel Podcast

               

The Excel fill handle is really cool with quarters. But wait….it can not do quarters and years. But wait…it can do them but in a hideous format. Episode 1132 asks – “Does anyone have a better way?” This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new(…)

First Week of Month – 1129 – Learn Excel from MrExcel Podcast

               

A dueling podcast…how to find the first week of the month. Mike and Bill show you various ways in Episode 1129. 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!

Opening Balance VLOOKUP – 1115 – Learn Excel from MrExcel Podcast

               

Brett from Australia asks how to format a date to include the words Opening Balance so that he can do a VLOOKUP into a report. The format is easy, the VLOOKUP is tougher. Episode 1115 shows you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a(…)

Years Months Days – 1113 – Learn Excel from MrExcel Podcast

               

Med asks how to calculate Years, Months, Days between two dates. Episode 1113 discusses the elusive DATEDIF function. 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!

Learn Excel from MrExcel