Episode # 212 - Last day of February?

Sponsored by

Learn Excel from MrExcel

Check out this book for more tips
similar to this lesson!

Thursday, March 16, 2006

How can you convert a date to the last day of the month? This is hard! 31 days? 30 days? 28 days? 29 days? What is the leap year rule? Never mind - this St Patrick's day podcast solves the problem without worrying about any of those issues. Episode 212 shows you how.

You don't need to go spend an entire day at the local computer chain store to learn Excel. Take 3 minutes to learn this lesson now with our free video!

Click Play icon to play the video. You might first need to click on the Video to activate Flash player.

Tags/Keywords for this video: Formulas, Dates

More Excel Video Lessons

If you like this video, there are hundreds of 2-5 minute videos available here:

Excel training videos about Charts
Excel training videos about VBA
Excel training videos about Pivot Tables
Excel training videos about Data Analysis
Excel training videos about Formulas
Excel training videos about Formatting
Excel training videos about Printing
Excel training videos about Excel 2007
Excel Video Lessons Index

Daily Dates to Months for Real | Set up a Simple Time Sheet

MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

MrExcel.com Consulting can be hired to implement this concept, or many other cool applications, with your data.

Excel is a registered trademark of the Microsoft® Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.
MrExcel.com debuted on November 21, 1998.

All contents Copyright 1998-2012 by MrExcel Consulting.
This episode published on March 16, 2006
Privacy Policy