dates

Coercing Dates – 1019 – Learn Excel from MrExcel Podcast

               

You can solve the MWF problem from episode 1018 using an incredible array formula from the book Excel Gurus Gone Wild. Episode 1019 takes a look at how to coerce an array of dates from a start date and end date cell. This video is the podcast companion to the book, Learn Excel 97-2007 from(…)

Fiscal Quarters – 1012 – Learn Excel from MrExcel Podcast

               

Vaibhav asks how to group a pivot table up to fiscal quarters. While this is easy if your fiscal years ends on December 31, it is not so easy for other year-ending dates. Episode 1012 shows you how. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new(…)

MrExcel’s Learn Excel #986 – Rounding NOW()

               

Many people use =NOW(), but it is frustrating when you try to calculate how many days away a certain event is occurring. Episode 986 shows a method for solving this problem. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn(…)

MrExcel’s Learn Excel #964 – Thu Mar 5, 2009

               

I bet you thought that I screwed up and put the date of the podcast as the title! But no… that really is the title. Tony asks how to change the long date format to show Thu Mar 5, 2009. Episode 964 shows you how. This video is the podcast companion to the book, Learn(…)

MrExcel’s Learn Excel #947 – Wrong Date Format

               

You get a CSV file from an International branch of your company and the dates are in M/D/Y when you use D/M/Y or vice versa. There is an easy solution. Episode 947 shows you how. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video(…)

Learn Excel from MrExcel