Excel - Bob Umlas Fill 15th & Last of Month Episode 1833
1,623 views · Published 11 December 2013 · 2:48 · Indexed 12 November 2026
Channel: MrExcel.com · 2013 · Education
Microsoft Excel Tutorial: Efficiently Fill the 15th and Last Day of the Month in Excel | Excel Tips with Bob Umlas. Welcome back to the MrExcel netcast! In this episode, we have a special guest, Bob Umlas, who will be sharing some valuable Excel tips with us. Bob is a Microsoft Excel MVP and has been a part of the program since its inception. Today, he will be showing us how to fill the 15th and last day of the month in Excel. The goal is to have the 15th of the month followed by the end date of the month, and then the 15th of the next month and so on. Bob will demonstrate a few attempts that we might make to achieve this, and then show us the best and most efficient way to do it. In the first attempt, we might try using the fill handle. However, this results in a messy and inconsistent data set. The end of every month is not exactly 15 or 16 days, so this method is not accurate. In the second attempt, we start with the 15th of every two months and then use the Go To Special function to fill in the blanks. While this method is better, it still has some flaws. The best way to achieve our goal is to start with the 15th and last day of the month, and then use the right-click fill handle option to fill in the rest of the dates. This method is quick, accurate, and saves us a lot of time and effort. Thank you, Bob, for sharing this amazing tip with us. We will have more podcasts from Bob in the coming weeks, so stay tuned for more Excel knowledge and tips. Don't forget to leave your comments and suggestions in the comment section below. Thank you for watching, and we'll see you next time for another netcast from MrExcel. Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Bob Umlas' 15th & Last of the Month (00:19) Attempt 1: Using the fill handle (00:30) Attempt 2: Starting with the 15th of each two months (01:16) Using the "Go To" function to select blanks (01:46) Best way: Using the fill handle options (02:26) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: Attempt 1: Fill handle mess Attempt 2: Fifteenth of each two months Bob Umlas 15th & Last of the Month Fill handle in Excel Fill months option in Excel Formula for calculating month following a date Go To Special function in Excel Learn Excel from MrExcel podcast episode 1833 Microsoft Excel MVP More podcasts from Bob Umlas Right-clicking fill handle in Excel Simplifying tasks in Excel Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153657/ You need to fill the 15th & last of the month. Excel MVP Bob Umlas shows you a trick from his book, Excel Outside the Box. For more information on his book, see: http://www.mrexcel.com/outsidethebox.html
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920