MrExcel's Learn Excel #942 - First of Next Month

Tags:: Excel Business Accounting Spreadsheets Tutorials Technology Mrexcel Formula Date

Edit Video Details

Share
Add to Favorites
Report
Download

By: MrExcel
Subscribers: 10
Updated: 25-Nov-09
Videos: 223

International
Comments: 0
Views: 296
Added: 03-Feb-09

Rod has a formula in column B that calculates the earliest month in a data set. He then wants formulas in C, D, E, and so on that show the first of the next month. Although you can right-click the fill handle to do this, Episode 942 will show you how to solve this using the DATE function.

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 one of the 377 tips from the book!